Posting your request numerous times, SHOUTING in the subject title, your not
responding to the qustions/answers already posted in response, has, in fact,
stopped me from helping you. This is not a programming service.


--
p45cal


"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.