CONCATENATE help

[jamaral141989]

So I have a formula as such =IF(M3=TRUE, "Eampletext, "") but within this example is more then 255 characters, and its asking to use the CONCATENATE function. I've tried a few ways but none work. Any thoughts?

[Pepe Le Mokko]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.
http://www.excelforum.com/excel-form...rate-help.html

[Glenn Kennedy]

Try either
=IF(M3=TRUE, "Eampletext", "")

or refer to a cell reference containing the long text string...