HOW TO USE THE CONCATENATE FUNCTION TO COMBINE DATA
If you want to combine fields together you can use the concatenate function. Let’s say you have first and last name in separate fields but you want to combine them into one field to create a mailing list.
Click in an open cell like C1
The Insert Function window will open.
Select the Category as “Text”
Within that category select “Concatenate”.
Use Excel's window to define the formula.
Excel will show you what the formula results will be as you define the formula.
If you want a space between names, you have to define a blank space as part of the formula.
