Select the cell.
Edit/Replace
    Find: $Y
    Replace with:  X

    Replace
    Close

should do it.

--ron

You could just highlight all the cells with that formula and do a Find
(Control-F) and replace all the $Y with $X.

Jim

Hi Tom

Highlight this cell and any other cells you want to do this to.  If you only
want to do this on one cell then highlight this cell and any other blank cell.

Then Ctrl+H --> Replace: Y$ --> With: X$ --> Replace All

Hope this helps
Jon