Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training course - Excel
|
|
|
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. |
excel training course - Excel
Resolved · Low Priority · Version Standard
Reply Thu 13 Dec 2007, 17:17Delegate Adam said...
For upcoming training course dates see: Pricing & availability
Reply Fri 14 Dec 2007, 11:37Delegate Paul said...
RE: excel
Concatenate joins a series of data together.
e.g. =concatenate(A1,B1) will join together the data in cells A1 & B1
if you wanted a space, you should type =concatenate(A1," ",B1)
anymore help, just ask
Paul
RE: excel
Dear Paul
Again thank you very much for posting the answer for this question !!
The best example would be when you have two fields such as First Name and Last name and you want both of them to be joined together!!
If you are using the Function dialog box to do Concatenate then please refer to the attached file!!
|