Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems Inserting Objects in an Excel 2007 Spreadsheet | Excel Discussion (Misc queries) | |||
Inserting part of a Spreadsheet into the Current Spreadsheet | Excel Discussion (Misc queries) | |||
Inserting data into Word document by a range of dates from Excel spreadsheet | New Users to Excel | |||
Inserting a MS Word object into an Excel spreadsheet (2 questions) | Excel Worksheet Functions | |||
Inserting picture in an Excel spreadsheet | Setting up and Configuration of Excel |