Replace text in a cell with text in another cell

[bristol]

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 (e-mail address removed) 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?

(e-mail address removed)

 

[Tom Ogilvy]

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)