Barrie Sharples wrote:
Hi Folks,
This is my first posting.
O.O. Spreadsheet - help please.
I have started compilation of an extensive list of ancestors which
comprises of five columns, first two text, second, whole numbers,
(birth, death, life span) as follows:
A B C D E
Smith Tom 1840 1910 70
I have planned for extraction of some data e.g. infant deaths, average
lifespan, no.'s achieving age majority, longest living etc.
However I have hit a problem extracting some information, using the
above example:
I can add a formula which sorts out the oldest survivor, OK, but I
would like to precede that cell result with the relevant column A & B
(The named individual) so it would read something like:
Oldest surviving ancestor: Smith Tom 70 yrs
Everything I have tried fails, and I have read & re-read the 'O.O.
Help' without success, it must be possible (And probably simple) but
too much for my poor old brain!
Can anyone help me?
Barrie Sharples
In F1 enter the formula
="Oldest surviving ancestor: " &A1 &" " &B1 &" " &E1 &"yrs"
The ampersand is the concatenation operator that joins two text strings
together; Calc is smart enough to treat numbers as strings in this context.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
