question about find/replace

New Contributor

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

 

 

4 Replies

@patriotrod 

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'.

@Hans Vogelaar 

This is how I set it up

patriotrod_1-1670423702011.jpeg

 

 

 

This was the result

patriotrod_0-1670423646851.jpeg

 

@patriotrod 

Instead of $$/$$ use ??/?? as in my first reply.

sorry, my bad
tried it again with success!!!!!!
Thank You so much Hans