Splitting and Extracting data

[JaredC]

I really hope someone here can help me. I have imported text into exce
which is currently in A1-A4600; quite a bit of info. The dat
previously looked like this:

ST last name, first name STORE# ADDRESS CITY ZIP Phone

I was able to get the ST (state) in column A, and the last name i
column C by using the text to column function. In column C, I need th
first name. This data can be any length, contain a nick name or middl
inital so it would have to extract all the text up to the first numbe
for the store number.

Can someone help me out on this one

 

[Guest]

You might try the delimited and check the box with space, depending on the
type of data