# substituting from one column to another

#### dftf

##### New Member
I have two columns. The letter in one column needs to replace number(s) in the other column.
A 2.003
A 2.003
B 6.007
B 6.007
C 10.011
C 10.013
D 15.016
D 15.016
D 15.016
D 15.021
D 15.022
E 24.025
F 27.028
G 31.032
H 35.036
H 35.038
I 39.041
I 39.042
J 44.045
A 2.003
A 2.003
A 2.003
B 7.008

The A needs to replace the 2, the B needs to replace the 6, the C needs to replace the 10, etc.

The catch is that it isn't always the same letter/number combination. Looking at the end of the sample, the B needs to replace the 7 in the next set.

Is there a formula I can apply to make this substitution?

Thank you!

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Will this do it for you:

=A1&RIGHT(B1,LEN(B1)-FIND(".",B1)+1)

HTH,

Smitty

Perhaps:

=REPLACE(B1,1,FIND(".",B1)-1,A1)

Copy down.

Replies
1
Views
276
Replies
15
Views
290
Replies
0
Views
159
Replies
2
Views
153
Replies
4
Views
173

1,203,203
Messages
6,054,099
Members
444,702
Latest member
patrickmg17

### 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