Add space between 2 columns in calculated column

Copper Contributor

Hi,

 

I am trying to create a calender view for my sharepoint list where the text shown for each list item is a combination of 2 or more columns in the calender view.

 

I have created a calculated column like this 

 

=Title&Score&Assigned 

 

This combines the text, number and choice from the 3 columns, however i would like to add a space inbetween each column to the final display is like this

 

Title Score Assigned

 

Instead of 

 

TitleScoreAssigned

 

How can i achieve this?

 

Thanks in advance

1 Reply

@kristian9210 

Hello Kristian, 

 

You have to add " " between your fields. 

example: 

=FirstName&" "&LastName