CAN ANYONE GIVE ME VB CODE TO REMOVE INITIALS FROM A NAME AND ATTACH IT TO THE END OF THE NAME??

C

CAPTGNVR

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
 
C

CAPTGNVR

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

Mike
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

NEED VB CODE TO REMOVE INITIALS FROM A NAME AND ATTACH IT TO THE END OF THE NAME 2
PLS SUGEST VB CODE TO REMOVE INITIALS FROM NAME AND ATTACH IT TO THE END OF THE NAME 6
VB NEEDED TO SHIFT INITIALS FROM BEGINING OF THE NAME TO END OF THE NAME 4
NEED VB TO REMOVE INITIALS FROM A NAME 4
WHAT COULD BE THE REASON FOR VB SCRIPT REGULAR EXPRESION TO WORK O 4
Can I use a variable contain the name of a sub or function to call it? 4
VB Code to save a copy of the workbook as another name 2
VB CODE for password protected sheet to release part of the worksh 8

Top