Inserting Cell Reference within text in a cell.

Question

Hello,

I am trying to insert the contents of a cell from a separate worksheet in the same book into a section of text.

What I am trying to do is:

="Text Text Text Text - INSERT CELL REFERENCE - Text Text Text - INSERT CELL REFERENCE - Text"

Can this be done?

I have tried "&CellREF&" and "CONCATENATE" but they do not seem to work in the above case. I just get a #Value error

Any help would be appreciated.

Answer 1

Any use?

best wishes

Answer 2

Replace Other sheet with your actual sheet name and actual cell on that sheet.

="Text Text text " & 'Other Sheet'!C4 & " text text text " & 'Other Sheet'!D7 & " text"

Answer 3

YES! I realised why it was not working before. I merged cells together and was referencing the merged cells. N.B. Always use the unmerged cells or the initial cell in the sequence!