Inserting Cell Reference within text in a cell. - Microsoft Community

Ask a new question

Inserting Cell Reference within text in a cell.

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.

 

Any use?

best wishes

http://people.stfx.ca/bliengme
A Guide to MS Excel 2013 for Scientists and Engineers

57 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

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"

16 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

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!

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated May 20, 2024 Views 36,313 Applies to: