How to Split the First & Last Name

[niladri20052006]

Hi All,

In one cell I have the contact names look like below

Lee Chee Kin
Nasution bin Abdul Rahman
Shahabuddin bin Tunku Besar Burhanuddin
Hironobu Nakamura

I want to split as First Name & last Name. It is not be easy if I apply "TEXT TO COLUMNS".

I want only the last letter will be in a cell and the remaining letter in a cell like below
A B
Lee Chee Kin
Nasution bin Abdu Rahman

Is there any formula to help me out?

 

[Scott Huish]

It's hard to tell from your post what you want exactly?
The last letter?

Breaking apart names is never going to be exact because of multiple words in the name as you have posted.

If you assume the last name to be only the last word, that is simple enough.
If you want something different, please clarify.

Excel Workbook
	A	B	C
1	Lee Chee Kin	Lee Chee	Kin
2	Nasution bin Abdul Rahman	Nasution bin Abdul	Rahman
3	Shahabuddin bin Tunku Besar Burhanuddin	Shahabuddin bin Tunku Besar	Burhanuddin
4	Hironobu Nakamura	Hironobu	Nakamura
Sheet1

 

[niladri20052006]

HI

it is awesome!!!

Thanks a lothttp://www.mrexcel.com/forum/member.php?u=25188