| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to Columns Letters and Numbers
How do I split a cell with numbers and letters into 2 separate cells. I have
tried the text to columns wizard and can't figure it out. Here is an example of what I am trying to split. There are no spaces between the numbers and letters. A1: 9A A2: 9B A3: 19A A4: 19C |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Columns are numbers (instead of letters). How to revert? XLS | Excel Worksheet Functions | |||
| columns appear as numbers not letters | Excel Discussion (Misc queries) | |||
| I have numbers instead of letters on my columns, why? | Excel Discussion (Misc queries) | |||
| Help, my columns now have numbers instead of letters. | Excel Discussion (Misc queries) | |||
| Columns in letters vs numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
