|
| 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 |
|
#11
June 28th, 2005, 09:25 PM
|
|||
|
|||
I need a similar effect to the one above, but my list contains names in the form LASTNAME, FIRSTNAME MI. and I want to remove the middle initials. Not all of them have a middle initial in them. Thanks! -- JFALK ------------------------------------------------------------------------ JFALK's Profile: http://www.excelforum.com/member.php...o&userid=24728 View this thread: http://www.excelforum.com/showthread...hreadid=381827 
|
|
#12
June 28th, 2005, 10:15 PM
|
|||
|
|||
|
On Tue, 28 Jun 2005 15:25:51 -0500, JFALK
wrote: I need a similar effect to the one above, but my list contains names in the form LASTNAME, FIRSTNAME MI. and I want to remove the middle initials. Not all of them have a middle initial in them. Thanks! Try this: =IF((LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1)," ","")))2, TRIM(A1),LEFT(TRIM(A1),FIND(CHAR(1),SUBSTITUTE( TRIM(A1)," ",CHAR(1),2))-1)) --ron
|
|
#13
June 29th, 2005, 02:57 PM
|
|||
|
|||
|
Ron Rosenfeld Wrote: On Tue, 28 Jun 2005 15:25:51 -0500, JFALK wrote: I need a similar effect to the one above, but my list contains names in the form LASTNAME, FIRSTNAME MI. and I want to remove the middle initials. Not all of them have a middle initial in them. Thanks! Try this: =IF((LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1)," ","")))2, TRIM(A1),LEFT(TRIM(A1),FIND(CHAR(1),SUBSTITUTE( TRIM(A1)," ",CHAR(1),2))-1)) --ron THANK YOU! It worked perfectly! -- JFALK ------------------------------------------------------------------------ JFALK's Profile: http://www.excelforum.com/member.php...o&userid=24728 View this thread: http://www.excelforum.com/showthread...hreadid=381827
|
|
#14
June 29th, 2005, 03:33 PM
|
|||
|
|||
|
On Wed, 29 Jun 2005 08:57:46 -0500, JFALK
wrote: THANK YOU! It worked perfectly! You're welcome. Glad to help. --ron
|
|
#15
September 26th, 2005, 02:40 PM
|
|||
|
|||
|
I have a list of names that includes at leats one first name.
I need to reduce the first name to its initial so that my list which is William Smith Joseph Bloggs etc becomes W Smith J Bloggs etc... Thanks Dave Glynn
|
|
#16
September 26th, 2005, 06:13 PM
|
|||
|
|||
|
Maybe you could use a formula:
=LEFT(A1,1)&MID(A1,SEARCH(" ",A1),255) dave glynn wrote: I have a list of names that includes at leats one first name. I need to reduce the first name to its initial so that my list which is William Smith Joseph Bloggs etc becomes W Smith J Bloggs etc... Thanks Dave Glynn -- Dave Peterson
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| creating/defining relationship between two tables | Giz | New Users | 2 | April 18th, 2005 09:24 PM |
| how do I remove blank pages in the middle of my word document | Tena | General Discussions | 1 | January 20th, 2005 07:07 PM |
| office 2000 remove tools | bud | Setup, Installing & Configuration | 1 | May 27th, 2004 10:40 AM |
| Identifying Upper case or identifying a single initial | Peo Sjoblom | Worksheet Functions | 1 | January 23rd, 2004 07:41 PM |
| Remove spaces in the middle of a cell? | Jacqueline Bendana | Worksheet Functions | 1 | October 1st, 2003 10:07 PM |
Linear Mode
