Thread: formula to add a number to a long string **
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default 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?
Reply With QuoteReply With Quote