# merge columns

##### Board Regular
27.xls
BCDE
1HAL_PT1HAL_PT2HAL_PTSRI Want
2101/01
3202/02
4303/03
5424/24/2
6535/35/3
7646/46/4
8757/57/5
9868/68/6
24

I want the desired result as in comlumn named "I Want". Please help me with a suitable formula.

Thank you.

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.
=IF(C2=0,D2,IF(D2=0,C2,C2&"/"&D2))

HTH
Cal

This does not solve my problem.

I would like to clarify the problem more clearly:

I enter 1 in cell 1 and 2 in cell a2 , while 0 in b1 and 1 in cell b2.

Now I want to merge both the columns (a,b) and and get the result in column c1 as 1 and 2/1 in cell c2.

Please provide a suitable formula to help me get rid of the problem.

=IF(B1 = 0, A1, A1 &"/" &B1)

however if there's a 0 in the column a it will put 0/b not sure if this is what you want. or if you want it to be just 0.

The results you listed in your example, are exactly what are returned by my formula.
1
2
3
4/2
5/3
6/4
7/5
8/6

You must be putting it in the wrong place. Your data columns in your example were column B for the first number, and column C for your second number. If they are different you will need to change the formula cell references.

HTH
Cal

Book1.xls
BCDE
1HAL_PT1HAL_PT2HAL_PTSR
22101
33202
44303
55424/2
66535/3
77646/4
88757/5
99868/6
Sheet1

Replies
5
Views
484
Replies
1
Views
143
Replies
4
Views
421
Replies
3
Views
156
Replies
7
Views
284

1,203,629
Messages
6,056,418
Members
444,862
Latest member
more_resource23

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back