apply formula to all cells

Do you mean like this:

Please Login or Register  to view this content.

[/FONT]

I'm a little confused because your thread title doesn't seem to match your question. So I don't know which one to answer.

If you need to make the same change to a whole bunch of cells you can use Find & Replace, make sure you select "Look in Formulas".