Better version of "If cell is not blank get value"?

[5150photo]

I concatenate a lot of text in my formulas and I am constantly writing different versions of this formula:

Please Login or Register  to view this content.

sometimes it's looking at a straight cell. Other times it's with a VLookup:

Please Login or Register  to view this content.

Is there a better way to do this check? In long formulas it seems like this adds unneeded glut.
I am thinking something like:

Please Login or Register  to view this content.

And if the cell has contents it would use it if not it would just be blank.

Is there a formula like that or a better approach in general?

[Tony Valko]

If the target cell contains text you can use the T(...) function.

=IF(A1="","",A1)

=T(A1)


=IF(VLOOKUP(A1,Data,2,FALSE)="","",VLOOKUP(A1,Data,2,FALSE))

=T(VLOOKUP(A1,Data,2,0))

[Phuocam]

Or try this ...

=VLOOKUP(A1,Data,2,0)&""

[5150photo]

Both of those are much better solutions.

Thank you guys so much.

[Tony Valko]

You're welcome. Thanks for the feedback!