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