Populate Countersign Formula with airSlate SignNow

Merge countersign formula

today you're going to learn how to combine data from multiple cells so for example you have values in multiple cells and you want to combine them in a meaningful way i'm also going to show you a bonus trick where you have text and number combined but excel doesn't see the text part completely ignores it this way you can use this text and number combination in your formulas you can use it in the sum function and calculate totals sounds interesting right let's take a look okay so here we have name and amount and we want to combine these in a dynamic way so that if our cell values change the result is automatically going to be updated we're going to start off with an equal sign go and select a2 now use an ampersand to combine this value with the value in another cell you're not restricted to two cells you can combine this with any number of cells that you want you would just continue and put in the next ampersand select your cell until you're done with your selection in this case we just want to combine these two values and i get bill and 1000 stuck together this doesn't look so good it's going to be better if we add a space in between to do that edit your formula right after the first emperor's end put in the quotation marks in here you can add any type of text that you want if you just want a space put in a space put in the quotation mark again but check this out if you try to leave the formula right now you're going to get this error there's something wrong with it it's not complete yet the problem is that you cannot combine text directly with a cell reference what you need in between is this ampersand don't forget to add that in there once you do that you get bill space 1000. now if you want to add something else in theirs if you want to add a dash you can do that or space dash space and our results updates automatically now we can easily just double click and send this down and get these in a dynamic way because they're formulas if i update any of these names here the result is automatically going to be updated so i'm just going to press ctrl z to go back now in case you want your numbers to be formatted properly so let's say in this case i wanted to show that this is a thousand dollars i can do that as well i'm just gonna remove that dash so we're just gonna go back to the space and just before the number i'm gonna type in the dollar sign press enter and now we have bill one thousand dollars if i send this down jessica one thousand dollars and so on if you want to have more space you can...