Thread: VB NEEDED TO SHIFT INITIALS FROM BEGINING OF THE NAME TO END OF THE NAME
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CAPTGNVR CAPTGNVR is offline
external usenet poster
  
Posts: 115
Default VB NEEDED TO SHIFT INITIALS FROM BEGINING OF THE NAME TO 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. This is posted again as my first one did not get posted.

Reply With QuoteReply With Quote