Concatenate result does not have space

[Jherjher001]

Good day,

I'm currently using this formula for my concatenate result but it does not seem to have a space. I would like to ask if there is a way I can have a space between the concatenate result.

Here's the formula that I am using.

=IF(=Sheet2!A1=" "," ",=Sheet2!A1)&ROUNDUP(IF(=Sheet3!A2=" "," ",IF(=Sheet2!A1<>" "," "&=Sheet3!A2,=Sheet3!A2)))


Thank you.

 

[jtakw]

Hi,

I doubt that formula works at all, all the equal = signs in front of Sheet2! don't belong, and you don't have the "number of digits" for the ROUNDUP function.

When you get your formula sorted out, add &" "& in your formula where you want the space.
Also, your IF test is checking for a SPACE " ", Not if it's Blank ""