I see now, I had no idea that one has to take into account that English names
can occur in "Smith, L James" like format that is an initial stands for the
first name followed by an entire name as middle name.

Stefi

€žRon Rosenfeld€� ezt Ã*rta:

On Wed, 26 Nov 2008 03:48:01 -0800, Stefi
wrote:

Hi Ron,

I don't understand the first part of your post: my UDF will remove not only
the first but all initials if they are one character long.

No doubt, it will not remove initials followed by "." but none of the
initials in the OP example is followed by ".".

Regards,
Stefi


Yours will remove Initials that are not "Middle Initials"

e.g.

Smith, L James

In this case, L is a "first name" initial, not a middle initial, but your
routine returns:

Smith, James
--ron