Combining two texts on two cells into one cell

If you have data in two cells and you would like to merge them into a cell. We can do that using CONCATENATE formula, please look into the below example,





In the above example, we have first name and last name of a person in cells A1 and B1. We merged the two names in C1 using =CONCATENATE(A1,” “,B1) formula and we had inserted a space (“ “) between two names.. The formula just merged the values exit in the two cells.