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...
|