If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I remove Salutation
Can anyone help me to remove Salutation and name to two different fields. I have a list of names like this. Mr Ravindran, Mrs Ravindran 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=492154 |
#2
|
|||
|
|||
How can I remove Salutation
Salutation: =LEFT(A1,FIND(" ",A1)-1)
Remainder: =MID(A1,FIND(" ",A1)+1,1024) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "m_ravindran" wrote in message ... Can anyone help me to remove Salutation and name to two different fields. I have a list of names like this. Mr Ravindran, Mrs Ravindran 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=492154 |
#3
|
|||
|
|||
How can I remove Salutation
Assuming your list in column A
In B1 put: =LEFT(A1,FIND(" ",A1,1)) In C1 put: =MID(A1,FIND(" ",A1,1),99) copy both down as far as you have data in Column A. Vaya con Dios, Chuck, CABGx3 "m_ravindran" wrote: Can anyone help me to remove Salutation and name to two different fields. I have a list of names like this. Mr Ravindran, Mrs Ravindran 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=492154 |
#4
|
|||
|
|||
How can I remove Salutation
Thanks, Bernard. It is extremely helpful. Regards, 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=492154 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to remove the timings and narrations | Abhishek | Powerpoint | 2 | January 12th, 2005 10:52 AM |
Word Templates Remove | Timo | General Discussion | 3 | December 21st, 2004 09:15 AM |
Total remove of Office xp pro | Lou | Setup, Installing & Configuration | 3 | November 10th, 2004 09:19 PM |
office 2000 remove tools | bud | Setup, Installing & Configuration | 1 | May 27th, 2004 10:40 AM |
Can't Remove Shadow Boxes | Ken | Worksheet Functions | 1 | April 22nd, 2004 06:21 PM |