An IF function returning both text and a cell value help

[robvasey]

I am trying to find a way for an IF function to return both text and the characters from a field. What I have now, and what I am looking to get are this.

Say A1=Text 2, or a number or something and I have
=IF(........, "Text 1...<A1>",.....)

I need the A1 in the IF to actually show the value of what is in box A1, not physically the spelling A1. What I would be looking for would be "Text 1 Text 2", as what Excel returns on a true statement.

The hard part is I can only find out how to either return text, or return the cell value. I don't need what is in A1 to actually be computed as anything, but it is just the end solution to be displayed.

Thanks for the help in advance.

 

[Scott Huish]

Hi, welcome to the board!

Are you looking for something like this:

="Text1" &A1

 

[robvasey]

Yeah, that does it. I figured there must be a way to do it, I just wasn't sure the format. Thanks so much for the help I really appreciate it.