Type the name is cell A1 (last, first) and then enter these formulas in
B1 =MID(A1,FIND(",",A1)+2,LEN(A1))
C1 =MID(A1,1,FIND(",",A1)-1)
If the name in cell A1 is last, first (without space after the symbol
"," ) then the formula in cell B1 will have to be
B1 =MID(A1,FIND(",",A1)+1,LEN(A1))
Now you can copy paste these two in any no. of rows...
Thanks
Karthik Bhat
Bangalore
|