| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Deleting text from number cells
Does anyone know of a quick and easy way to remove text characters from within a number? My numbers look like 186R1114F0010, 186011T3F0233 and 18H01135F0557. I have about 3,000 cells to convert to an all numeric number per day. Currently I am using the find/replace function on every letter in the alphabet. This works well but is a little tedious.
thank you for any help you can give |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting characters in a column of cells -converting to text strin | Excel Programming | |||
| Macro For Deleting Cells Containing A Number | Excel Programming | |||
| Finding & deleting cells that do not contain a certain text string | Excel Programming | |||
| Moving, deleting, and concatenating text in cells. | Excel Worksheet Functions | |||
| deleting certain text from cells | Excel Worksheet Functions | |||
Threaded Mode
