Forum Discussion

Jolyon's avatar
Jolyon
Icon for Helper III rankHelper III
9 years ago
Solved

add a blank when merging 2 columns?

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!

Need Help
  • JoHo_BI's avatar
    JoHo_BI
    9 years ago

    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!

1 Reply

  • JoHo_BI's avatar
    JoHo_BI
    Icon for Responsive Resident rankResponsive Resident
    9 years ago

    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!