ExcelBanter - Merging a hyperlinked cell with a non-hyperlinked cell?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Merging a hyperlinked cell with a non-hyperlinked cell? (https://www.excelbanter.com/excel-discussion-misc-queries/202079-merging-hyperlinked-cell-non-hyperlinked-cell.html)

ALEX

Merging a hyperlinked cell with a non-hyperlinked cell?

I have two cells that need to be merged. Both are text and one has a
hyperlink. How do I combine the two and keep the hyperlink?

Bob I

Merging a hyperlinked cell with a non-hyperlinked cell?

One way with the hyperlink in say A1 and the other text in B1 is to edit
the text in the hyperlink cell from

'original text

to

="original text"&B1

Alex wrote:

I have two cells that need to be merged. Both are text and one has a
hyperlink. How do I combine the two and keep the hyperlink?

All times are GMT +1. The time now is 07:05 PM.