formula to add a number to a long string **

[MMangen]

I'm not quite sure how to best describe this:

I need a formula that will take the example below and return the "final
result"

Col. A = 24.43.234.555 and Col B= 23 making Final Result = 24.43.234.578

Is there a way to do this?

 

[ryguy7272]

This seems to work:
=LEFT(A1,LEN(A1)-3)&(RIGHT(TEXT(A1,"0"),3))+23

HTH,
Ryan---

 

[L. Howard Kittle]

=LEFT(A4,10)&--RIGHT(A4,3)+B4

Where 24.43.234.555 is in A4 and 23 is in B4.

HTH
Regards,
Howard

 

[Teethless mama]

=TEXT(SUBSTITUTE(A1,".","")+B1,"00\.00\.000\.000")

 

[Rick Rothstein]

You conditions are not well formed. Your first two numbers seem to indicate
that the other numbers do not have to be 3-digits long. So, if your Column A
value was this instead...

12.345.67.89

and the Column B number was still 23, would the answer be 12.345.67.66 or
something else? If single digit final numbers are permitted, the if the
Column A number was this...

12.345.67.8

then what would the answer be?

 

[minyeh]

According to Rick, my formula is

=LEFT(A1,FIND(" ",SUBSTITUTE(A1,".",REPT(" ",99),3)))&RIGHT(SUBSTITUTE
(A1,".",REPT(" ",99),3),99)+B1

under the assumption that there's 4 section in the text string (or 3
dotes)