I would like to replace certain text in a cell with text in the adjacent
cell. For example, I have someone's first name in one cell and I have
a email address layout like in the cell next
to it. I would like to write a macro to replace "firstname" with the
cell next to it with the person's first name. Similarly, then, I have
someone's last name in another cell and I would like to write a macro
to replace "lastname" with the cell with the person's last name.

Any macro writers who can help?





------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/