Forum Discussion
question about find/replace
I want to know if i can find and clear variable text. I have displayed a very small spreadsheet (the real one is huge) and the text I want to delete in the cells is "PURCHASE AUTHORIZED ON XX/XX but...
Select the range.
Press Ctrl+H to activate the Replace dialog.
In the 'Find what' box, enter
PURCHASE AUTHORIZED ON ??/??
Leave the 'Replace with' box empty.
Click 'Replace All'.
Instead of $$/$$ use ??/?? as in my first reply.
- sorry, my bad
tried it again with success!!!!!!
Thank You so much Hans
