Yes, but you and the OP may want to think about how you wish to deal with

--
David Biddulph

"Stefi" wrote in message
...
This formula will do that:
"

Regards,
Stefi

"LydiaD" wrote:

I would like to convert a large number of e-mail addresses from one
naming
convention to another... ex " needs to become
". The finished product should consist of six lastname
characters and 1 first initial. Can I use a macro for this? Any advice
would be appreciated.