Salutation: =LEFT(A1,FIND(" ",A1)-1)
Remainder: =MID(A1,FIND(" ",A1)+1,1024)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"m_ravindran"
wrote in message
...

Can anyone help me to remove Salutation and name to two different
fields.
I have a list of names like this. Mr Ravindran, Mrs Ravindran Ms
Ravindran, Miss Ravindran etc. I want to have the Salutation in one
cell and the name in the other.

Thanks in advance.

M. Ravindran


--
m_ravindran
------------------------------------------------------------------------
m_ravindran's Profile:
http://www.excelforum.com/member.php...o&userid=28668
View this thread: http://www.excelforum.com/showthread...hreadid=492154