Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting certain characters from a long string | Excel Worksheet Functions | |||
Long string of IF formulas | Excel Discussion (Misc queries) | |||
Extract sub-string of number from field of long series of numbers | Excel Worksheet Functions | |||
How do I specific digits in a long string? | Excel Discussion (Misc queries) | |||
Transposing a Long String | Excel Worksheet Functions |