posts inserted into text...
----- Original Message -----
From: "David Pettersson" <[EMAIL PROTECTED]>
Subject: Re: [users] Calc: compress columns.
[ snipped ]
Is there a function to test if a cell is empty?
=ISBLANK(celladdress) returns TRUE or FALSE
How do I concat a constant string to a cell content?
="constant string"&celladdress
=celladdress&"text"&"Text"&celladdress
The constant text can be concated before, after, in between other
cell contents. Separate the arguments with an ampersand (&) and enclose any
constant strings in double quotes.
When I copy a formula, how do I prevent cell H4 to change to H5, H6, H7
...
(while H6 in the same formula still should change this way)?
Use the $ sign in front of elements of a cell address that you want
to remain unchanged.
$A$4 would remain pointing to cell A4 when copied.
A$4 would continue to point to row 4, but the column would change
relative to "A" if the formula is copied to other columns.
$A4 locks the column to always be "A", but the row number will
change when the formula is copied.
If I get the last questions answer I can complete my work, if I get all
answered I can understand what I have done next month as well :)
/David Pettersson
[ remainder snipped ]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
