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
