Concatenate columns using LEFT and RIGHT in EXCEL

0 votes

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.

2 days ago in Others by Kithuzzz
• 20,660 points
7 views

1 answer to this question.

0 votes

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.

answered 2 days ago by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

How to hide and unhide the columns of an excel sheet using asp.net

Use this. For Row: worksheet_sub.Row(i).Height = 0; For Column: ...READ MORE

answered Oct 29 in Others by narikkadan
• 37,660 points
56 views
0 votes
0 answers
0 votes
1 answer

How do I get an Excel range using row and column numbers in VSTO / C#?

Use: int countRows = xlWorkSheetData.UsedRange.Rows.Count; int countColumns = xlWorkSheetData.UsedRange.Columns.Count; object[,] ...READ MORE

answered Nov 17 in Others by narikkadan
• 37,660 points
25 views
0 votes
0 answers

Combining MID and LEFT Functions in Excel 2019

I currently have a course name and ...READ MORE

9 hours ago in Others by Kithuzzz
• 20,660 points
3 views
0 votes
1 answer

Excel formula to remove comma, spaces, period and add a text

The steps to accomplish this are as ...READ MORE

answered Mar 15 in Database by gaurav
• 22,040 points
634 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
137 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
230 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17 in Others by Edureka
• 13,640 points
101 views
0 votes
1 answer

How can I find and replace text in Word using Excel VBA?

Try this code Option Explicit Const wdReplaceAll = 2 Sub ...READ MORE

answered Oct 15 in Others by narikkadan
• 37,660 points
85 views
0 votes
1 answer

Get number of columns of a particular row in given excel using Java

Use: int noOfColumns = sh.getRow(0).getPhysicalNumberOfCells(); Or int noOfColumns = sh.getRow(0).getLastCellNum(); There ...READ MORE

answered Oct 24 in Others by narikkadan
• 37,660 points
105 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP