Excel Tutorial - Using function to combine text "=CONCATENATE()"
This is a Tutorial on combining two or more Text strings using Microsoft excel.
This is very helpful if you are handling large data sheet and for Automation of preparing repetitive scripts.
The CONCATENATE function joins up to 255 text strings into one text string. The joined items can be text, numbers, cell references, or a combination of those items. For example, if your worksheet contains a person's first name in cell A1 and the person's last name in cell B1, you can combine the two values in another cell by using the following formula:
=CONCATENATE(A1," ",B1)