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

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

Where B2 contains city name and C2 contains Zip Code.

CodePudding user response：

It might be possible that your version of Excel doesn't support Concat/concatenate function. Try to use the below formula

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

& here does the same thing as concatenate function.

Let me know if you need any further clarification.