How can we separate First Name, Middle Name and Last Name

0 views
Skip to first unread message

Ashu K

unread,
May 13, 2015, 8:03:24 AM5/13/15
to Excel...@googlegroups.com
Dear Seniors,

How can we separate First Name, Middle Name and Last Name.

Kindly share easiest formula for the same.



Thanks & Regards
Ashu Kenith 

Ashish Kumar

unread,
May 13, 2015, 8:13:25 AM5/13/15
to Excel VBA Lab
Dear Ashu,

PFA...!!



Regards
Ashish Kumar
First Name, Middle and Last Name.xlsx

Ashu K

unread,
May 13, 2015, 8:24:19 AM5/13/15
to Excel...@googlegroups.com
Dear Ashish Sir,

Thanks for your quick response.

Formula is working perfect..!!

bilalkml

unread,
May 14, 2015, 8:07:07 AM5/14/15
to Excel...@googlegroups.com
Please tell me what is the function of 256 ... I cant understand the use of 256.

Ashish Kumar

unread,
May 14, 2015, 8:26:43 AM5/14/15
to Excel VBA Lab
Hi Bilalkml,

"256" indicates the number of character that you want to extract.


Regards
Ashish Kumar
Reply all
Reply to author
Forward
0 new messages