Excel notes

Merging two text columns into a single column (concatenation, concatenate):

"=A2&B2"

Remember you can convert numbers into text to accomplish this if needed.

To include a space between text from different columns:

=A2&" "&B2

To convert all caps to capitalize first letter only:

=PROPER(A2&" "&B2)

To convert a formula column into a static column (ie text or number):
Highlight the column of interest, Copy, then Paste Special into a new column-> Value. Can then select all cells and format into appropriate type.

Reference: http://www.mrexcel.com/tip074.shtml