Replace text in a cell with text in another cell
 

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/

Replace text in a cell with text in another cell
 

You can create a hyplerlink like this using the Worksheet hyperlink function
(in help). I would look at that first and if it doesn't do what you want,
then post back.

=Hyperlink( arguments)

--
Regards,
Tom Ogilvy


"bristol" wrote in message
...
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/