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

Guest

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

Guest

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
HOW TO SPLIT INITIALS IN A NAME - my first post - pls help 4
WHAT COULD BE THE REASON FOR VB SCRIPT REGULAR EXPRESION TO WORK O 4
VB Code to save a copy of the workbook as another name 2
Can I use a variable contain the name of a sub or function to call it? 4

Top