Forum home » Delegate support and help forum » Microsoft Excel Training and help » vba-excel-training - Merging columns
|
|
|
The UK's most regular 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
vba-excel-training - Merging columns
Resolved · Low Priority · Version Standard
Reply Tue 13 Nov 2007, 12:59Delegate Lorna said...
Lorna has attended:
Excel Advanced course
Merging columns
Is it possible to merge two columns so that the data in both merges into one? For example one column has first names and the other has surnames, can they be merged so each cell contains both the first and surname?
For upcoming training course dates see: Pricing & availability
Reply Tue 13 Nov 2007, 14:41Delegate Paul said...
RE: Merging columns
Hi Lorna
It's best to use concatenate for this.
let's say your data is in columns A & B
in cell C1, type =concatenate(A1, ,B1)
This will pull the names together. Notice that I've put a space in between the two columns in the brackets. This will put a space between the first name and surname for you..
Hope this helps
Paul
Reply Tue 13 Nov 2007, 14:48Delegate Lorna said...
RE: Merging columns
Thanks Paul
That is going to save me hours!
Lorna
Reply Tue 13 Nov 2007, 14:51Delegate Paul said...
RE: Merging columns
Anytime mate
|