Need to remove selected characters
I have 25000 cells with map coordinates in it in the following format:
N34* 51.87'
I need the data in the following format:
N55 13.26
So basically I need to strip out the * and ' from each cell. Any simple way
to do this? I sure would appreciate any assistance.
Thank you
--
Dale
|