If a cell contains text, insert that text within a sentence in another cell

Copper Contributor

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

@Jodes1675 

Like this:

=IF(B27<>"","I want to show this sentence with (" & B27 & ") in the middle of it.","")