Please Help

  • Thread starter Thread starter m_ravindran
  • Start date Start date
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
 
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 9
rename 13
Text to Columns help 8
Extract strings intelligently from single cell 0
How to sort a list with Mr, Mrs, Miss ? 5
combine titles/names - how? 7

Back
Top