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.
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.