Character Limit on IF Statement Result

[bobbyrooney]

I currently have this formula =IF(L3<>"",L3, "") pulling text descriptions from cells, and ignoring blank cells, but need to limit the character length to 15 characters. I tried nesting a (LEFT(L3,15)) function, but it would not take. Is there a way to do this?

I tried this but it wouldn't take.
=IF(LEFT(L3,15), L3<>"",L3, "")

 

[Eric W]

Maybe:

=IF(L3<>"",LEFT(L3,15),"")

 

[steve the fish]

You could just use:

=LEFT(L3,15)

Blank cells would produce a blank result.

 

[bobbyrooney]

Thank you both! Both methods worked! Much appreciated!