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)


On Nov 25, 8:37*am, "Rick Rothstein"
wrote:
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?

--
Rick (MVP - Excel)

"MMangen" wrote in message

...



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?- Hide quoted text -

- Show quoted text -