Walt

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