How to use the Excel CONCATENATE
How to use the Excel CONCATENATE function and the Excel PROPER function.
This video will teach you how to nest two text functions, CONCATENATE and PROPER together to combine two text columns together and properly case the text.
The video explains in simple detail how this formula works:
=PROPER(CONCATENATE(A2,", ",B2))