formula to add a number to a long string **
 

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?

formula to add a number to a long string **
 

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

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"MMangen" wrote:

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?

formula to add a number to a long string **
 

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

Where 24.43.234.555 is in A4 and 23 is in B4.

HTH
Regards,
Howard

"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?

formula to add a number to a long string **
 

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


"MMangen" wrote:

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?

formula to add a number to a long string **
 

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?

formula to add a number to a long string **
 

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 -