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.

Last Updated: Dec 10, 2019     Views: 25

Chat With Us!

Business Library chat is offline

Related Topics