I want to enter a formula into a column so that:
if the cell is empty, a space will be added.
if the cell is not empty, nothing will be done.

(The purpose is to tidy up a spreadsheet so that long entries don't
stray over a column's right hand edge.)

So far I've only been able to achieve this by inserting a new column
alongside and creating the formula there, then pasting its values into
the target column. Otherwise I get in a mess with messages about
circular references.

Am I attempting the impossible please?

--
Terry, East Grinstead, UK

Hi Terry,

Am Sun, 22 Feb 2015 18:30:23 +0000 schrieb :

(The purpose is to tidy up a spreadsheet so that long entries don't
stray over a column's right hand edge.)

select the column with the long entries = Right click = Format Cells
= Alignment = Horizotal = Fill

Or if you entries are in column A then in B1:
=IF(LEN(A1)0," ","")


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Hi Terry,

Am Sun, 22 Feb 2015 18:30:23 +0000 schrieb :

(The purpose is to tidy up a spreadsheet so that long entries don't
stray over a column's right hand edge.)

if right of the column with the long entries is a column that is not
completly filled you can insert spaces into the empty cells with:
Select the column = Find & Replace = Replace:
Find Nothing and replace with a space


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Claus Busch wrote:

Hi Terry,

Am Sun, 22 Feb 2015 18:30:23 +0000 schrieb :

(The purpose is to tidy up a spreadsheet so that long entries don't
stray over a column's right hand edge.)

if right of the column with the long entries is a column that is not
completly filled you can insert spaces into the empty cells with:
Select the column = Find & Replace = Replace:
Find Nothing and replace with a space


Regards
Claus B.

Duh! That's exactly what I want, thanks a bunch. So simple now you've
told me ;-)

--
Terry, East Grinstead, UK