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.