Jherjher001
New Member
- Joined
- Jan 6, 2018
- Messages
- 3
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.
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.