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
Where B2 contains city name and C2 contains Zip Code.