Dec 07 2022 06:03 AM
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
Dec 07 2022 06:10 AM
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'.
Dec 07 2022 06:36 AM
Dec 07 2022 06:52 AM
Instead of $$/$$ use ??/?? as in my first reply.
Dec 07 2022 07:23 AM