DAER ALL
I have 3 thou odd names in excel97. The names are entered like
A.S.R.CHARLIE;
P.K.WHITE; M.PETER and so on.

Can u pls sugest VB code so that I can run through each cell and take
these initials

and attach it at the end of the name after giving a space or two like
CHARLIE

A.S.R; PETER M. and so on. Pls help.

I

Yes, People have many times in you other posts, why not read them.

Mike

"CAPTGNVR" wrote:

> DAER ALL
> I have 3 thou odd names in excel97. The names are entered like
> A.S.R.CHARLIE;
> P.K.WHITE; M.PETER and so on.
>
> Can u pls sugest VB code so that I can run through each cell and take
> these initials
>
> and attach it at the end of the name after giving a space or two like
> CHARLIE
>
> A.S.R; PETER M. and so on. Pls help.
>
> I
>
>

On Jul 19, 4:08 am, Mike H <Mi...@discussions.microsoft.com> wrote:
> Yes, People have many times in you other posts, why not read them.
>
> Mike
>
> "CAPTGNVR" wrote:
> > DAER ALL
> > I have 3 thou odd names in excel97. The names are entered like
> > A.S.R.CHARLIE;
> > P.K.WHITE; M.PETER and so on.
>
> > Can u pls sugest VB code so that I can run through each cell and take
> > these initials
>
> > and attach it at the end of the name after giving a space or two like
> > CHARLIE
>
> > A.S.R; PETER M. and so on. Pls help.
>
> > I

D/MIKE
lol. . No Mike, I checked extensively in the discusion group and
came with only four answers when I used TRIM, INITIALS etc. But it
did not suit my requirement. Will u give me the link I will read.
Moreover, last two days I kept posting this and I cud not see the
post. May be some probs with the server.