Adding 3 Field into 1 Field

raymond.wong · November 5, 2021, 3:45pm

Hi There,

Would like to Add 3 field into 1 field. A4 +’ ’ +A5 +’ ’ +A6

however, if A5 is empty, it will create additional space in between A4 and A6.

Anyway that if A5 is empty, it will not create a space?

Thanks in advance.

Regards
Raymond

kanefranco · November 6, 2021, 12:05am

Hi Raymond,

I think I follow what it is you would like to do here!

Try: A4+IF(A4=’’,’’,’ ‘)+A5+IF(A5=’’,’’,’ ‘)+A6+IF(A6=’’,’’,’ ')

raymond.wong · November 8, 2021, 3:08pm

Hi Kanefranco,

Thanks but I tried the formula seems to have an error, saying that formula is not correct.

Regards
Raymond

hank · November 9, 2021, 2:55am

Hi,

You could try this out, IF(A5.RAW=’’,A4+’ ‘+A6,A4+’ ‘+A5+’ '+A6)
When to add .RAW, please refer to this article:

raymond.wong · November 9, 2021, 3:33pm

Thanks All,

I managed to get it right and here is the formula.

IF(A6.RAW=’’,’’,A6+" “)+IF(A7.RAW=’’,’’,A7+” “)+IF(A8.RAW=’’,’’,A8+” ")+IF(A9.RAW=’’,’’,A9)

Cheers
Raymond