druddle

Hello all

Can I ask for some more help from the Excel wizards ?

I am trying to use the replace function but I am not sure its the right thing, and even if it can do what I want.

I have a cell, A1 with the contents "bf400_p4unulf01", A2 has "28". In A3 I want to have the resulting output that says "9.0.0.28", where...

9.0. is entered as text
0. is generated because of the 1 in the string "bf400_p4unulf01"
28 is taken from cell A2

in the same manner, I have a cell, B1 with the contents "bf400_p4unulf02", A2 has "43". In A3 I want to have the resulting output that says "9.0.1.43", where...

9.0. is entered as text
1. is generated because of the 2 in the string "bf400_p4unulf02"
43 is taken from cell A2

I have tried with REPLACE and I cant get the 0. or 1. to appear in the right place.

Does anyone understand what I want to get, and how to do it ?

Thanks

Dave

DJ Dunk

iTrader: (5)

Dave,

Can you confirm the rules for the 3rd part of the IP address?

1 = 0
2 = 1

Minus one each time?

If so:


=CONCATENATE("9.0.",RIGHT(A1,1)-1,".",B1)

. . . in cell C1 and drag it down.

druddle

Hi Dunk,

Yes you are correct , 1=0, 2=1.

Dave

DJ Dunk

iTrader: (5)

This should work a treat then

=CONCATENATE("9.0.",RIGHT(A1,1)-1,".",B1)

bioforger

iTrader: (1)

Looks like a good formula to me