Merge Signed Electronically Formula with airSlate SignNow

Combine formula document

in this video I'm going to show you how you can use multiple Excel functions to split manipulate and rejoin values inside a single formula here we have some sample data and in column B we have text values with a number at the end what we want to do is increment these numbers using the values in column C now if I try to do this directly with a formula that adds c5 to b5 I'll get an error because the value in B is text and Excel won't let you add numbers and text so what I need to do is extract the number then do the math then put things back together again let's do that step-by-step first I'll use the write function to extract the three characters from the right this gives us the number you can see by the left alignment that the number is still in text format however now I can add the value from column C this time it works because Excel is able to convert the text to a number automatically as part of the math operation we get a correct result of two but we lose the padding with zeros so let's add the padding back using the text function the text function lets us apply a number format inside a formula I just need to wrap the existing formula in the text function and then use zero zero zero as the number format okay so now we have an increment at number padded with zeros the final step to rejoin this number to the original text using simple concatenation to do that I'll just hard code the text item with a space at the start of the formula then use the ampersand to join the text to the padded number we already created when I hit return we get our final result and you can see that the number is incremented properly now I can just copy the formula down the table to increment the remaining values when you face a problem like this the key is to work in small steps and verify your progress as you go the final result may look complex but in most cases each piece of the formula is doing something very simple