Please Help

[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

[duane]

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

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