What is "&" used for??

  • Thread starter Thread starter GEM
  • Start date Start date
It is the concatenation operator - used for joining text together,
like:

="The winner is "&A1

Hope this helps.

Pete
 
What is the "&" symbol used for in a function?
Click to expand...

String concatenation.

You can get a description of operators by entering "operator" in the
search field for Excel Help (2003), then clicking on "About
calculation operators", then "Types of operators".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vba macro that allows insertion of symbols at cursor 0
How to make a new currency symbol 5
Using Data Import with URLs and Pointers 2
Excel Count If Formula Question 1
Excel formula ^ 1
VBA Question 9
Find text, replace it but now I need to change the height of allpreceding/following text 10
Square symbol 4

Back
Top