Hi Ngan,

I have a free download on my website which shows you have to do this. There
are also many other excel websites with text formulas and text downloads. Do
a search "excel separate lastname, firstname".

Cheers,
--
Kevin Lehrbass
www.spreadsheetsolutions4u.com


"Access Front End" wrote:

Hi Anyone!

How do you FIND a string in a cell. I know that in C language you can use
"string" but what do you use in Excel. I have a cell that contain First name
then comma some time a space then Last Name. How can I get the Firstname in
one column & Last name in one column by using the formula. Thanks

Ngan