Seperate the first name, middle name and last name containing in one cell

[satputenandkumar0]

Hi fourm,

I have workbook contain customers full name I have to seperate it as First Name, Middle Name and Last Name.

pls find attached workbook.

Regards,
Nandkumar satpute

[dogberry]

Hi

Go to your Data Tab use text to columns and a space as your separator that should do it for you.

Chris

[satputenandkumar0]

Dear dogberry

It works perfect.

Thanx & Regards,
Nandkumar Satpute

[:) Sixthsense :)]

In B3 cell

Please Login or Register  to view this content.

Drag it down and right

[dogberry]

Hi
Pleased to help dont forget to mark your thread as solved.

Chris