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 g...
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!

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!