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