Problem using the "&"

[MuskyMan]

I'm sure there is a simple reason, but...

Using Excel 2002 and need to use the MID function.

Need to perform the following in a cell:

=MID(B1,2,3) &"-" & MID(B1,5,7)

What happens is that as soon as I type & Excel changes it to an "and" and I get an error message.

Thanks for your help!

 

[CubeE101]

use + instead & Sometimes... the BASIC things in life are the best...

or at least the most fun ;-)
-Josh Stribling

 

[scottsek]

I think the problem is that you have the autocorrect "Replace text as you type" option on and there is an entry in the autocorrect for &/and so that as soon as you type & it replaces it with and. Go to Tools/AutoCorrect Options and either uncheck the "Replace Text As You type" or delete the &/and entry from the dictionary.

Scott

 

[CubeE101]

you can use:
+ trim(str(x))
in place of:
& x

if all else fails Sometimes... the BASIC things in life are the best...

or at least the most fun ;-)
-Josh Stribling