=CONCATENATE(IF('Cap Quote Request '!L6=0,"",'Cap Quote Request '!L6),IF('Cap Quote Request '!L7=0,"",'Cap Quote Request '!L7))
I am pulling together two words from another sheet. It works except instead of the words showing up as
Dog Cat
Its showing up as
DogCat
with no space. Could anyone please help me with this minor snaffu. Thanks in advance.
Bookmarks