Concatenate result does not have space

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.
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

jtakw

Well-known Member
Joined
Jun 29, 2014
Messages
5,146
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 ""
 

Watch MrExcel Video

Forum statistics

Threads
1,109,066
Messages
5,526,576
Members
409,712
Latest member
lager2020

This Week's Hot Topics

Top