Forum Discussion
Jodes1675
Oct 07, 2021Copper Contributor
If a cell contains text, insert that text within a sentence in another cell
At the moment, I've got:
=IF(B27<>"","I want to show this sentence with ("B27") in the middle of it.","")
Obviously the ("B27") is wrong and here I want the actual text that's written in B27.
Any ideas? Thank you so much!
1 Reply
Like this:
=IF(B27<>"","I want to show this sentence with (" & B27 & ") in the middle of it.","")