Merge Signed Formula with airSlate SignNow

Merge number text

in Excel you can use a formula to combine data from two or more cells so here we have a column with first name and last name and we'd like to combine them so I'm going to click here where I'd like to see the full name and type an equal sign and then click on b2 which has the first name to join the values I'm going to type shift 7 which creates an ampersand and that joins text in Excel then I'll click on the last name now when I press ENTER its combined the names but they would look better if there were a space between them so I'm going to click there where the formula is and just click after the b2 so right after the first name I'd like a space so I'll type another shift 7 to get an ampersand and to create a space I'm going to type a space here inside double quotes so I'll type double quote space and a double quote and now when I press ENTER there's the first name space last name and I can just copy that down you can also combine text in numbers so here we have a price list our orders have come in and I'd like to combine the product name and the total amount of each sale so I'll do the same thing that I did with the customers I'll type equal click on the product name shift 7 and put a space in there another ampersand and click on the amount and that combines the product name and the amount but this isn't formatted too nicely if I want to format numbers or dates when I combine them then I can use the text function so just in a separate cell we'll see how that works I can type equals text2 an Open bracket and now it's looking for two arguments the value we want to format and how we want it formatted so the value is the amount and a comma and I would like this as currency so inside quote marks I will type quote and then I'll use a dollar sign and a number sign comma number sign number sign 0.00 so that's going to format it with commas and two decimal places and I'll put double quotes at the end and a closing bracket when I press ENTER this is the formatting we would like to see inside our combined cell data so instead of typing it again in the other cell I'm just going to copy this formula except for the equal sign and go to this formula and all select that e 2 and just paste the text formula there and when I press Enter there's the formula now with the number formatted and when I copy it down it formats all these amounts with currency