Please Help

M

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, ZXY Company, Mrs
Ravindran, ABC Inc. 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
 
D

duane

one way, if they are all in one column is to select the range (singl
column) and choose, data, text to columns, and choose the appropriat
break.

a formula to do it would use the find and left or right functions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I remove Salutation 3
Typing an Address List 3
sort help 12
Sort by help 1
Help with Macro on moving data with headers into larger file.. 0
Text to Columns help 4
Mail Merge - List multiple items then page break on unique data 1
rename 13

Top