NEED 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.
 
P

p45cal

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

CAPTGNVR

So very sorry and I apologise. The fact is I am on a ship in remote area and
the conection is so bad. Last two days this post was not getting posted and
was getting google sending error. Hope u understand and if I would have seen
any questions asked, I would have responded immy and it is for my own
interest.
Once again sorry and pls be accomodating for we all novices and new entrants
in this art of programming.
 

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

PLS SUGEST VB CODE TO REMOVE INITIALS FROM NAME AND ATTACH IT TO THE END OF THE NAME 6
CAN ANYONE GIVE ME VB CODE TO REMOVE INITIALS FROM A NAME AND ATTACH IT TO THE END OF THE NAME?? 2
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
HOW TO REMOVE 'SHEET TABS' FROM OPTIONS MENU IN VB 3
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Remove initial from end of name 8

Top