Remove middle initial from "first name middle initial"
- From: Justin F. <Justin F.@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 23 Jun 2005 18:02:02 -0700
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.
.
- Follow-Ups:
- Re: Remove middle initial from "first name middle initial"
- From: JFALK
- Re: Remove middle initial from "first name middle initial"
- From: Ron Rosenfeld
- Re: Remove middle initial from "first name middle initial"
- From: Max
- Re: Remove middle initial from "first name middle initial"
- Prev by Date: Re: Answering InpBox prompt
- Next by Date: Re: Answering InpBox prompt
- Previous by thread: Automatically put negative sign in cells with positive numeric dat
- Next by thread: Re: Remove middle initial from "first name middle initial"
- Index(es):
Relevant Pages
|
