add a blank when merging 2 columns?

[Jolyon]

Hi everyone,

need a little help:

I want to merge 2 columns with CONCATENATE([column1]; [column2]) and I get for example "10111Adworks"

But how can I add a blank between these values? -->to get "10111  Adworks"?

thanks in advance!

[JoHo_BI · Accepted solution]

Hi Jolyon,

Try using CONCATENATE([column1]&" ", [column2])

The ampersand let's you add another function, or in this case an empty space after the first parameter. 

Hope this meets your needs!