Search and replace? Search for 00/ and replace with <space, ditto for /00


On 15 Mar 2005 21:39:09 -0800, (Monty) wrote:

I would like to automatically change the text in a series of cells.
For example the value currently shown in the cell is "
00/05-05-097-5W5/00 ". How would I remove the 00/ & /00, so the cell
would show " 05-05-097-5W5 "?
I hope this is not too confusing. Thanks Monty