How do I add a space in a reference formula? I want the space to display between the two values that

April Feldt

Good Afternoon,

I have built an event calendar tracker. I want the display name on the calendar to include information from two columns of data. The formula I am using for calendar display is =Location1 + [Event Name]1. In the calendar display column I want a space between the location and event name.

L_123

=Location1 + " " + [Event Name]1

L_123

=Location1 + " " + [Event Name]1

April Feldt

Thank you.

L_123

No problem. Just a hint, if you are referencing something on the same row you can use the @row reference.

=Location@row + " " + [Event Name]@row

This speeds up the sheet, and is a more professional way to build your formulas. The difference is if you use a row number, the program has to update each formula individually on refresh which can result in a significant performance decline for larger sheets.

Not that you probably need to do this for the sheet you are building, but it is a good habit to get in.

https://help.smartsheet.com/articles/2476491-create-efficient-formulas-with-at-cell

CAS the CSA

how would you display multiple spaces? " "+" "+" " etc...?

I know char(9) isn't recognized...