How can I split contents of cell with no delimiter

G

Guest

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
 
D

Dave Peterson

If the text is always 2 characters, you can still use Data|text to columns. But
choose fixed width--not delimited.
 
G

Guest

that was even easier! thanks to everyone!

Dave Peterson said:
If the text is always 2 characters, you can still use Data|text to columns. But
choose fixed width--not delimited.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

point as delimiter 1
Changing the default delimiter 1
delimit using a formula 2
Transposing contents of a cell 6
Split column contents (de-concantenate) 7
HELP! Split cell contents to new rows 7
Text to Columns Problem 4
Use of multiple-character delimiters under Text To Columns 3

Top