Help with Find/Replace

  steviegee 10:30 30 Jan 08
Locked

On a spreadsheet I am highlighting a column and using find/replace to replace . with a space. Trouble is it removes them from other columns too, how do I do it so it just removes from that column on the spreadsheet? Thanks.

  steviegee 11:26 30 Jan 08

^

  VoG II 11:35 30 Jan 08

I've tried this and it only replaces them in the selected column (as it should).

  steviegee 11:46 30 Jan 08

Its not working for me. I highlight K and it removes from I also!

  steviegee 15:51 30 Jan 08

^

  MAJ 15:58 30 Jan 08

If you're using Microsoft Excel, try going to Help > Detect and Repair.

  steviegee 16:13 30 Jan 08

Done that but its still doing it.

  Woolwell 19:15 30 Jan 08

The only way I can get this to happen is when find and replace is open, clicking on options and selecting workbook instead of sheet. Check that you have sheet selected.

This thread is now locked and can not be replied to.

Hands-on: Samsung Galaxy S8 review

1995-2015: How technology has changed the world in 20 years

Samsung's beautifully designed Galaxy S8 makes for better VR experiences too

47 iPhone camera tips to help you take better photos