Concatenate columns using LEFT and RIGHT in EXCEL

Question

I have two columns:City Name and ZIP
Now, the same city names have different ZIPs I want to generate the third column which has the First Letter of City and the Last two digits of the ZIP Code.
For example, My city name is SACRAMENTO and my ZIP is 98532, I want to create a code as S32.
I have used the following formula. But it is not working

=CONCAT(LEFT(B2,1),RIGHT(C2,2))

Where B2 contains city name and C2 contains Zip Code.

Answer 1

It's conceivable that the Concat/Concatenate function isn't supported by your version of Excel. Try applying the formula below.

=Left(B2,1)&Right(C2,2)

& performs the same function as the concatenate function here. I hope this helps you.