Forum Discussion

Jodes1675's avatar
Jodes1675
Copper Contributor
Oct 07, 2021

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

Resources