substituting from one column to another

[dftf]

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!

 

[Smitty]

Will this do it for you:

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

HTH,

Smitty

 

[Scott Huish]

Perhaps:

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

Copy down.