0
Typed in literally it won't do anything, except show it in the cell. If you put the equals sign before it, it will give an error. The ampersand can be used to concatenate text, including spaces, so it is usually used in connection with other pieces of text in cells. So for example if you had America in cell A1 and in A2 type in:
="United States of "& A1
It would put United States of America in cell 2
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
What is the concatenation operator called for excel?
The ampersand, which is this character: &
Is the ampersand character the concatenation operator in excel?
yes
What is the motto of Ampersand Communications?
Ampersand Communications's motto is 'with Ampersand you always get more'.
What does the one squiggly line mean ampersand?
this is and ampersand......&
How do you write ampersand?
Ampersand is the known name for the '&' sign.
Ampersand in a sentence?
Ampersand is use for Title, and Fragments .
What is a sentence for Ampersand?
The ampersand is number seven on a standard keyboard.
When was Ampersand Communications created?
Ampersand Communications was created in 2001.
What is an ampersand key?
An ampersand key is this, & it is the 'and' short cut symbol.
How do you spell ampersand in Swedish?
Ampersand translates to et-tecken in Swedish.
How do you use ampersand in a sentence?
The ampersand is number seven on a standard keyboard.
What is an ampersand?
It is the full name for the text symbol "&" meaning "and" or "in addition to." You can use the ampersand by holding down the SHIFT and 7 keys, which will display the ampersand.
