exporting and importing

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Exporting and Importing

Exporting and Importing

resolvedResolved · 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


 

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.

View all Excel hints and tips


Server loaded in 0.09 secs.