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 don't know how.
Can I get some help on this?
Thanks,
Patriotrod
01/05/22 -$11.36 PURCHASE AUTHORIZED ON 01/05 TAR
01/05/22 -$2.25 PURCHASE AUTHORIZED ON 01/05 TAR
01/07/22 -$12.80 PURCHASE AUTHORIZED ON 01/05 TSC
01/10/22 -$100.00 PURCHASE AUTHORIZED ON 01/07 MIMI
01/10/22 -$38.09 PURCHASE AUTHORIZED ON 01/08 OD
01/10/22 -$5.04 PURCHASE AUTHORIZED ON 01/08 STA
01/10/22 -$109.12 PURCHASE AUTHORIZED ON 01/08 XXX
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.
