Y

#### Yann St-Germain

I'm using Excel 2000 (9.0.6926 SP-3) and I have the following problem:

I have the following formula in the cell B2:

=SUBSTITUTE(A2, "blabla", "")

Instead of showing the result of the formula I get the formula's text just

like if it was between double quotes... If I click on the "=" sign on the

top left to edit the formula, the formula shows up with the different

parameters filled in and the good result shows up on the bottom in the

dialog box.

I couldn't find anything in the newsgroups on this..

Is there something I'm doing wrong here? Any work around?

Thanks in advance!!

==========================

Yann St-Germain

Programmer - Analyst / Webmaster

CANAC Inc.