Tilted Forum Project Discussion Community - View Single Post

Walt · 11-09-2010, 05:41 PM

I was hoping someone here could help me out. I am trying to organize a course list for a friend. I have about 800 courses that are listed like so in column A:

ANT 1210 Introduction to Anthropology.

I would like to separate the course abbreviation and number (the first 8 characters) in to column A and the course title in to column B for all 800. Is there a quick formula I can plug in to do this for me or am I stuck doing it manually?

Thanks.

11-09-2010, 05:41 PM	#1 (permalink)
Walt I'm calmer than you are, dude Location: North Carolina	Need help with Excel I was hoping someone here could help me out. I am trying to organize a course list for a friend. I have about 800 courses that are listed like so in column A: ANT 1210 Introduction to Anthropology. I would like to separate the course abbreviation and number (the first 8 characters) in to column A and the course title in to column B for all 800. Is there a quick formula I can plug in to do this for me or am I stuck doing it manually? Thanks. __________________ Calmer than you are...