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

**satputenandkumar0** · 11-17-2012, 03:05 AM

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** · 11-17-2012, 03:12 AM

Hi

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

Chris

**satputenandkumar0** · 11-17-2012, 03:18 AM

Dear dogberry

It works perfect.

Thanx & Regards,
Nandkumar Satpute

**:) Sixthsense :)** · 11-17-2012, 03:18 AM

In B3 cell

Formula:

Please Login or Register  to view this content.

Drag it down and right

**dogberry** · 11-17-2012, 03:19 AM

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

Chris

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

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

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions