Help with Find/Replace

  steviegee 10:30 30 Jan 2008
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 2008

^

  VoG II 11:35 30 Jan 2008

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

  steviegee 11:46 30 Jan 2008

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

  steviegee 15:51 30 Jan 2008

^

  MAJ 15:58 30 Jan 2008

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

  steviegee 16:13 30 Jan 2008

Done that but its still doing it.

  Woolwell 19:15 30 Jan 2008

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.

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Converse draws on iconic heritage for a fresh brand identity

Mac power user tips and hidden tricks

Comment lancer Windows 10 en mode sans ├ęchec ?