Assuming your list in column A
In B1 put:
=LEFT(A1,FIND(" ",A1,1))
In C1 put:
=MID(A1,FIND(" ",A1,1),99)
copy both down as far as you have data in Column A.
Vaya con Dios,
Chuck, CABGx3
"m_ravindran" wrote:
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