Dividing name
 

I have a long coloumn with names and I need to divide them into first name
and last name. Is there a formula for the same.

Any help would be appreciated.

Thanks,
KD

Dividing name
 

Data Text to Columns Next select Space Next Finish


"kd" wrote:

I have a long coloumn with names and I need to divide them into first name
and last name. Is there a formula for the same.

Any help would be appreciated.

Thanks,
KD