Hello everyone,
I am trying to figure out a way in Excel to take all the text to the
right of a "-" symbol and put it in a new column.
For example;
If I have a list of albums in column A such as: "Bob Dylan-The
Freewheelin"
I'd like to have it so that it just says "Bob Dylan" in column A, and
"The Freewheelin" in column B.
Is there an easy way to do this with text sorting?
Or any other function in Excel that could easily do this?
It would save me a lot of time in doing it manually.
Thanks for taking the time to read this, I greatly appreciate any
insight you can give me.
Sincerely,
TM
KC Rippstein - 16 Feb 2007 19:18 GMT
Use the built-in function under Data -> Text to Columns
Tell it the "-" is what Excel should use as a separation point.
> Hello everyone,
>
[quoted text clipped - 17 lines]
> Sincerely,
> TM
travismacrae@gmail.com - 16 Feb 2007 20:26 GMT
That worked perfectly! Thanks so much KC!
-TM
> Use the built-in function under Data -> Text to Columns
>
[quoted text clipped - 25 lines]
> > Sincerely,
> > TM