PLS SUGEST VB CODE TO REMOVE INITIALS FROM NAME AND ATTACH IT TO THE END OF THE NAME
 

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.

PLS SUGEST VB CODE TO REMOVE INITIALS FROM NAME AND ATTACH IT TO T
 

Are all the names in a column?

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.

PLS SUGEST VB CODE TO REMOVE INITIALS FROM NAME AND ATTACH IT TO T
 

"Mike H" wrote in message
...
Are all the names in a column?


This has been asked and answered in an older thread.