Forum Discussion
kristian9210
Oct 11, 2021Copper Contributor
Add space between 2 columns in calculated column
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
- harunfb82Copper Contributor
Hello Kristian,
You have to add " " between your fields.
example:
=FirstName&" "&LastName