How to list all cells that contain a word

I need to show on cells in a column the cell location of every cell that has a word. How to do that?

  1. Ctrl+H - open Find&Replace form
  2. Type word to field Find
  3. Click Find All - all cells with this word will be selected
  4. Press Close (twice if it need)
  5. Press Ctrl+C or choose Edit-Copy
  6. Select first cell for result list
  7. Press Ctrl+Shift+V or choose Edit-Paste Special-Paste Special
  8. Check Link (set to ON) in group Options - then OK

Paste As Link

  1. Again press Ctrl+H
  2. Type equal sign = to field Find
  3. Click Replace All

Convert Formula To Text