How can I remove Salutation

[m_ravindran]

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

[Bernard Liengme]

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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[CLR]

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
>
>

[m_ravindran]

Thanks, Bernard. It is extremely helpful.

Regards,
Ravindran