If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
! removing initials and titles from name cell !
Hi,
I'm sure what I'm asking must have a simple solution, but I can't work out how to achieve it so thought I'd ask the experts. I have an addess list. It has names and some with initials, and titles. I'm looking for a macro, or some simple way to remove these characters from each name cell. Example: Bob A Lastnam & Jenny B secondname Jr Fred Blogs & John J Ashton ii What I want as the result is: Bob Lastname & Jenny secondname Fred Blogs & John Ashton Any suggestions on an elegant way to acheive this. I note that doing a replace on " "A" " with " " works within the cell, but not if the A is the last character in the cell. Thanks Ray |
Thread Tools | |
Display Modes | |
|
|