Excel Tip of the Day
For non-advanced Excel users like myself, I always find the need to merge the text from two columns into one. For example, the first and last names are in separate columns but I want them to be in one. While there is no "Merge Columns" command, it is actually pretty easy to do with a simple formula.
Step 1: Create a new column where you wanted your merged data to be
Step 2: Enter a formula like this:
B1is where the first name is.
C1is where the last name is, and
" "means you want a space between them. The
&does the merging.