Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please Help
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 -- m_ravindran ------------------------------------------------------------------------ m_ravindran's Profile: http://www.excelforum.com/member.php...o&userid=28668 View this thread: http://www.excelforum.com/showthread...hreadid=492163 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please Help
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. -- duane ------------------------------------------------------------------------ duane's Profile: http://www.excelforum.com/member.php...o&userid=11624 View this thread: http://www.excelforum.com/showthread...hreadid=492163 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|