Merging two cells in a simple way

If you would like to merge cells, without using CONCATENATE formula then we have a simple to do that. Below is the formula and example for that.




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 & symbol. The formula took the value in A1 and, it just merged it with the value in B1 and we had inserted a space between the two names using “ “. Like wise you can merge N number cells into a cell.