Search code examples
excelexcel-formulaconcatenation

Concatenate columns using LEFT and RIGHT in EXCEL

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.

Solution

  • 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.