excel: Edit cell???

[AL]

I know it's easy, but I forget how.
I imported a file from a data base to excel.
The names came over combines,
ie: (Sablone,Al A.) or (Sablone,AL) in one cell.
I would like to reformat the cell into two cells with
First_Name & Last_Name. & entire column

Could somebody hit my refresh key please.....

Thanks
ALLLL

 

[Anders S]

Al,

If You want to split the cell at the comma, here is one way.

If Your data starts in A1,
enter
=LEFT(A1,FIND(",",A1,1)-1) in B1
and
=MID(A1,FIND(",",A1,1)+1,2000) in C1
and fill down as required.

To freeze the values, select columns B and C and do Copy & Paste Special>Values.

HTH
Anders Silvén

 

[Chris Wagner]

Tools> text to column

Using the "," as a delimiter should work

Chris Wagner