| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I split contents of cell with no delimiter
Hi,
I have a column of text ny17 ca13 ky04 I want to be able to split the text and numbers into two separate columns, "ny" in one, "17" in another. As you can see there's no delimiter. Since I know excel can recognize the difference between text and a number I know there's a way to do it but I don't know what it is. Alternatively, I would be happy to find a way to insert a delimiter like a comma between the text and number to use "text to columns". Can anyone help? Thanks, Rebecca |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Split text into multiple columns using a common delimiter | Excel Discussion (Misc queries) | |||
| Excel 2000 - Split Contents of Cell Across Multiple Cells | Excel Discussion (Misc queries) | |||
| Split contents of a cell | Excel Worksheet Functions | |||
| Can unmerged cell contents be split to another cell | Excel Worksheet Functions | |||
| How to split the contents of a cell between two cells. | Excel Worksheet Functions | |||
Threaded Mode
