Try one of these:

"
or
")
or
"
or
")

Those formulas return:





Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Mark B." wrote in message
...

A B
Row 1 Mark Bressler
Row 2 Joe Smith

My data looks like the stuff above and I want to convert it into this:



In other words, I:

add xy. and the first letter of the first name to the last name
add @mark.net to the end of the last name.

Any help will be greatly appreciated.