excel: Edit cell???

  • Thread starter Thread starter AL
  • Start date Start date
A

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
 
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
 
Back
Top