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