Adding a Space into my macro

[Majesticz]

Hello

I'm having an issue adding a Space between a Name and a macro link



=CONCATENATE("Test Test","CHAR(10)",'[Payless-VZW-CradlePoint-Phase2.xlsx]Currently Staging'!$F$2)

This is what it looks like Test TestCHAR(10)202256 I need it to look like this Test Test 202256 Can anyone help me add the space between Test Test & 202256 Thanks <colgroup><col width="552"></colgroup><tbody> </tbody>

<colgroup><col width="552"></colgroup><tbody>
</tbody>

 

[dms37]

Hi,

This should do the job:

=CONCATENATE("Test Test"," ",'[Payless-VZW-CradlePoint-Phase2.xlsx]Currently Staging'!$F$2)

 

[Majesticz]

Thanks a bunch