| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to separate text and numbers
Hi, I have a spreadsheet with many rows of data containing a combination of
letters and numbers. I would like to be able to use formulas to separate the text from the numbers and end up with the letters in one cell and the numbers in another, so that the following: AB1 A20 TMH255 Would become: AB 1 A 20 TMH 255 Thank you in advance for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i separate numbers and text in a cell? | Excel Discussion (Misc queries) | |||
| Ascii iinput file - separate text from Numbers | Excel Worksheet Functions | |||
| Converting Text String to Separate Numbers | Excel Discussion (Misc queries) | |||
| How to separate numbers from text?? | Excel Discussion (Misc queries) | |||
| Formula to separate text in cell | Excel Worksheet Functions | |||
Threaded Mode
