Inserting & within Excel spreadsheet to show as &
 

I am trying to type the ampersand within an Excel spreadsheet and cannot
remember HOW to make it look like: &
When I do it, it thinks I am trying to do a command or a formula or
something. All I want to do is put this in my spreadsheet because it's the
name of a company: &

Thanks a bunch for the help!

Inserting & within Excel spreadsheet to show as &
 

if that's the sole character, put a quote mark in front of it.
if it's in the middle of a bunch of characters, it shouldn't trigger
anything.
if it does, try a quote mark at the beginning of the text.
:)
susan


On Oct 19, 1:35*pm, Melissa wrote:
I am trying to type the ampersand within an Excel spreadsheet and cannot
remember HOW to make it look like: * &
When I do it, it thinks I am trying to do a command or a formula or
something. *All I want to do is put this in my spreadsheet because it's the
name of a company: &

Thanks a bunch for the help!

Inserting & within Excel spreadsheet to show as &
 

inclose text in double quotes like
="ACME & Sons Co"

"Melissa" wrote:

I am trying to type the ampersand within an Excel spreadsheet and cannot
remember HOW to make it look like: &
When I do it, it thinks I am trying to do a command or a formula or
something. All I want to do is put this in my spreadsheet because it's the
name of a company: &

Thanks a bunch for the help!