Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » excel+training - Cocatenation
|
|
|
Bookmark this page|
The UK's most regular Training information: |
|
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 - Cocatenation
Resolved · Low Priority · Version Standard
ReplyFor upcoming training course dates see: Pricing & availability
RE: Cocatenation
Hi ChloeThankyou for your question
Cocatenation is a function that can be used to join a text string or variable to another text string or variable.
For example if you had a person's first name in cell A1 and their surname in cell A2 and you wanted to create a formula that would join the two together, with a space in between; then in the required cell you would type the following.
A1&" "&A2
The & symbol is the cocatenation function and in this instance joins the contents of A1 to a white space and then joins that to the contents of cell A2
Hope this helps
Regards
Stephen
|
 |
|
» Forum post: Headers |
If I wanted a different header on each page of a document how would I achieve this please.
