formula to add a number to a long string **

  • Thread starter Thread starter MMangen
  • Start date Start date
M

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?
 
=LEFT(A4,10)&--RIGHT(A4,3)+B4

Where 24.43.234.555 is in A4 and 23 is in B4.

HTH
Regards,
Howard
 
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?
 
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)
 
Back
Top