Thanks for the kind words.......I'm glad I could help.

***********
Regards,
Ron

XL2003, WinXP


"Mark B." wrote:


You're a genius! Thanks a ton.

Mark B.


"Mark B." wrote:


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.