Forum home » Delegate support and help forum » Microsoft Excel Training and help » Mergin cells
|
|
|
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. |
Mergin cells
Resolved · Low Priority · Version 7
Reply Tue 11 Oct 2011, 16:59Delegate Jennifer said...
Jennifer has attended:
Excel Introduction course
Mergin cells
How do I merge two cells where I have the first name and surname and want to make it into one cell so the whole name is in the box
For upcoming training course dates see: Pricing & availability
RE: Mergin cells
Hello Jennifer,
Thank you for your question regarding combining data from two cells into one cell.
This is done using the function CONCATENATE. An example of this would be as follows:
=CONCATENATE(A2," ",B2) where A2 contains the first name and B2 contains the last name. The ," ", creates the space between the names.
After completing the above then select all cells with the formula, copy and paste values. This will remove the formula and clean up the data.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
Attached files...
Concatenate_Names.xlsxReply Tue 18 Oct 2011, 12:58Delegate Barry said...
RE: Mergin cells
Hello Jennifer, you can also find your answer here http://office.microsoft.com/en-gb/excel-help/merge-and-unmerge-cells-HP005251021.aspx?CTT=5&origin=HA010338037 & the merge cells works ok.
Baz
|