Inserting Function blanks adjoioning cell

[Dave]

Occasionally, when I want to insert a cell address for a cell that is
immediately to the left of the one I am trying to put a formula in,
inserting the '=' sign blanks out both the cell I'm working on and the one
to the left. Of course, there are workarounds, but is there a way to not
have to 'work around' this problem?

Maybe I should add, often the cell in question is from another page, which
can make its address rather long.
Dave

 

[Max]

I'd just format the formula cell to left-justify temporarily, if required
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:15,700 Files:353 Subscribers:53
xdemechanik

 

[Dave]

Thanks Max - I'll give that a try

Dave

I'd just format the formula cell to left-justify temporarily, if required
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:15,700 Files:353 Subscribers:53
xdemechanik

 

[Max]

Welcome, Dave.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik

 

[Spiky]

Occasionally, when I want to insert a cell address for a cell that is
immediately to the left of the one I am trying to put a formula in,
inserting the '=' sign blanks out both the cell I'm working on and the one
to the left. Of course, there are workarounds, but is there a way to not
have to 'work around' this problem?

Maybe I should add, often the cell in question is from another page, which
can make its address rather long.
Dave

If I'm understanding you correctly, you could also turn off "Edit
directly in cell" in the Options.