Help

Adding a number to a string

Topic Labels: Formulas
2469 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Greyson
6 - Interface Innovator
6 - Interface Innovator

I have an Autonumber Column, I’d like to create a Formula that combines each Autonumber + a string “M”

Formula
“M” + {Autonumber}

Intended Result
“M1”

Current Result
NaN

Thank you

2 Replies 2
JT_Kirk
5 - Automation Enthusiast
5 - Automation Enthusiast

Try & instead of +

Solved, thank you @JT_Kirk