Joining 2 columns

Patricia Worth
Patricia Worth ✭✭✭
edited 12/09/19 in Smartsheet Basics

Hi, i need to join 2 columns. First column is the City Name and second is the Numbers. I got it to work but I only need the first 3 digits from the City : =JOIN(City1 + Number1) comes out CITYNAME3462

I need to show up CIT3462

thank you for the help

Comments