| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i use & sign without it thinking its a formula
I am trying to use a header that says Bldgs E & F but the & sign keeps going
away and only keeps the E F is there something i need to put in front of & sign to make is stay??? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i use & sign without it thinking its a formula
What are you typing into the header?
Excel uses the ampersand symbol to perform concatenations (joining text strings together) so perhaps it thinks you're trying to concatenate E and F. What happens if you put "E and F" in the header? -- Brevity is the soul of wit. "sonnie1964" wrote: I am trying to use a header that says Bldgs E & F but the & sign keeps going away and only keeps the E F is there something i need to put in front of & sign to make is stay??? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i use & sign without it thinking its a formula
Use two
&& -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "sonnie1964" wrote in message ... I am trying to use a header that says Bldgs E & F but the & sign keeps going away and only keeps the E F is there something i need to put in front of & sign to make is stay??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| an extra "+" sign in formula | Excel Discussion (Misc queries) | |||
| Formula bar doesn't have an equal sign | Excel Worksheet Functions | |||
| why does Equal sign not appear on the formula bar | Excel Discussion (Misc queries) | |||
| How to I use ** without Excel thinking I want to type a formula? | Excel Discussion (Misc queries) | |||
Linear Mode
