Hi Ron!

I'm "working" under the assumption that this data is in 3 cells.

first names(s)
middle inital
last name(s)

If you were to modify the UDF to return ALL first letter initals then at
least it could be used on the first name(s) cell then the mi and last
name(s) are easy enough.

Biff

"Ron Rosenfeld" wrote in message
...
On Wed, 1 Jun 2005 23:32:38 -0400, "Biff" wrote:

Try Ron's UDF!

The problem for the OP remains as I previously stated. How do you
differentiate a non-hyphenated two word last name from a middle name +
last
name?

Perhaps some kind of lookup table? But I just don't have any information
about
this.


--ron