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
|
|||
|
|||
Remove middle initial from "first name middle initial"
Hello Excel Gurus,
I've been searching the site for an answer to this question but as yet no luck. If I missed a previous post on this topic I apologize, please direct me to it. I have 1 column with a series of people's first names. Many have a middle initial, some don't. About half of the cells are of two people's names joined by an "&". Sample data below: Frank & Debbie J Marshall & Teresa Timothy R Jeffrey D & Eileen N Pamela J James R & Rachel Brooke S Myung S Martin F & Susan A Kathleen I need remove the middle initial and preserve the first names and the "&" with a single space between the names and the "&". Can anyone provide me with a way to do this? Many thanks in advance, Justin F. |
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 |