can't replace '

[JulieD]

have a worksheet made from imported data - all cells have ' in them (doesn't
show) - need to delete this where the cell is (otherwise) empty - tried find
& replace but says can find anything.

any ideas?

cheers
JulieD

 

[Ragdyer]

If you're talking columns and numbers, and not text, try Text To Columns.

Select a column, and then:
<Data> <TextToColumns> <Finish>.

If you're talking Text *and* Numbers, and more then just a few columns,
Right click in a *new* empty cell, and choose "Copy".
Select the cells that you wish to "fix", and right click in the selection,
and choose "PasteSpecial".
Click "Add", then <OK>, then <Esc>.

All the apostrophes ( ' ) should now be gone!