Row info split

[markjeff]

Hello

I have an execl spread sheet (un-normalized) I need to import in to an access db. Most info goes in fine however the first and last names in the excel sheet are grouped under one column separated by a ",". I have in the DB a separate column for first and last name.

I need to figure out how to split the column. Is this possible

 

[shades]

Howdy. Is there a space between the comma and the names?

If no space, then I assume that the last name is first, comma, First name (all with no spaces)

Assume name is in Column I, the use two more columns:

Last Name can be extracted to another column (I):

=LEFT(I38,FIND(",",I38)-1)

First Name in column K

=RIGHT(I38,LEN(I38)-FIND("*",SUBSTITUTE(I38,",","*",LEN(I38)-LEN(SUBSTITUTE(I38,",","")))))
________
Honda f20c engine history

 

[markjeff]

Thank that worked perfectly