| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| remove non-numeric characters from a cell | Excel Discussion (Misc queries) | |||
| remove last three characters of cell | Excel Discussion (Misc queries) | |||
| Remove characters from a text string using a formula | Excel Discussion (Misc queries) | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
Threaded Mode
