Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel programming vba - Text function
Stephanie has attended:
PowerPoint Intermediate Advanced course
How do you put 2 columns of data to appear as one?
Hi Stephanie. Let's assume there's data in cell A1 and cell B1. To combine the contents of those cells into cell C1 you need the formula "=A1 & B1". You can then use that formula to populate the rest of the column.
Hope this helps,
Anthony
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question.
Our Microsoft Qualified trainers will then respond within 24 hours (working days).
Frequently Asked Questions
What does 'Resolved' mean?
Any suggestions, questions or comments? Please post in the Improve the forum thread.
If you want to add more than one row to an Excel Worksheet, drag select the number or rows you want added to the spreadsheet.
Then right click on these selected rows, choose Insert from the menu, and the new rows will be added above the rows you first selected.
TrustScore
4.9
/ 5
2394 reviews
Call for assistance
We will call you back
Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.
