How do I merge 2 columns in Excel?
Enter your data in column A and column B. In Cell C1 enter the formula =A1&" "&B1. Drag the formula down to the bottom of column C. The formula for three columns would be =(A1&""&B1&""&C1). This formula is useful when converting company identifiers into a format that Bloomberg will recognize.
If you require further assistance, please contact us.