98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Exporting and Importing
Exporting and Importing
Resolved · Low Priority · Version 2003
Francesca has attended:
Excel Advanced course
Exporting and Importing
What is the meaning of CONCATENATE
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
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
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 tip:Counting Non Number Cells (Text)If you try to use the COUNT FUNCTION =COUNT(Cell range)with a range of cells with numbers and or containing text fields you wil find that that the text cells will be excluded from the the count. If you want to include them try the the COUNTA FUNCTION =COUNTA(Cell range). This counts both text and number cell values. |