Forum home » Delegate support and help forum » Microsoft Excel Training and help » Exporting and Importing
|
|
|
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. |
Exporting and Importing
Resolved · Low Priority · Version 2003
Reply Thu 21 Aug 2008, 17:20Delegate Francesca said...
Francesca has attended:
Excel Advanced course
Exporting and Importing
What is the meaning of CONCATENATE
For upcoming training course dates see: Pricing & availability
RE: Exporting and Importing
Hello Francesca
Hope you enjoyed your Excel training with BEST STL.
Thank you for your question regarding CONCATENATE
According to Google, here are some definitions of the word:
Adding two strings into a single string.
javascriptant.com/glossary/
combine two strings to form a single one
add by linking or joining so as to form a chain or series; "concatenate terms"; "concatenate characters"
wordnet.princeton.edu/perl/webwn
In computer programming, concatenation is the operation of joining two character strings end to end. For example, the strings "foo" and "bar" may be concatenated to give "foobar". ...
en.wikipedia.org/wiki/Concatenate
To join or link together, as though in a chain
en.wiktionary.org/wiki/concatenate
Hope that answers your question.
Regards
Richard
Microsoft Office Specialist Trainer
Reply Wed 27 Aug 2008, 19:44Delegate Veronika said...
RE: Exporting and Importing
Hi Francesca,
In Excel, the Concatenate function allows you to join 2 or more strings together.
The syntax for the Concatenate function is:
Concatenate( text1, text2, ... text_n )
There can be up to 30 strings that are joined together.
Applies To:
Excel 2007, Excel 2003, Excel XP, Excel 2000
For example:
Let's take a look at an example: (imagine excel spreadsheet)
A B C
1 Alpha
2 bet
Based on thespreadsheet above:
=Concatenate(A1, A2) would return "Alphabet"
=Concatenate("Tech on the ", "Net") would return "Tech on the Net"
=Concatenate(A1, "bet soup") would return "Alphabet soup"
Hope this has helped :-)
Veronika
RE: Exporting and Importing
Thank you for the additional information
Richard
|