Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / February 2007

Tip: Looking for answers? Try searching our database.

Excel Text Sorting? An Easy Solution

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
travismacrae@gmail.com - 16 Feb 2007 18:20 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.