Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
replace part text in a cell | Excel Discussion (Misc queries) | |||
Can I replace a ' at the beginning of a text cell using Replace | Excel Discussion (Misc queries) | |||
find text in cell and replace it with part of the text in that ce. | Excel Discussion (Misc queries) | |||
to replace only the last text/chracter in a cell | Excel Discussion (Misc queries) | |||
How do I change replace text in a cell for different text? | Excel Worksheet Functions |