Paul Smith wrote:
On 3/17/07, Peter Larsen <plarsen@xxxxxxxxxxxxxxxxxxxxxxx> wrote:
Why not simply use the spreadsheet to do this?
You can calculate a text string as well as a nummeric result.
In open office, use concatenate, and then hlookup for each field.
Create a list with the text corresponding to your nummeric value. Give
it a heading (very important) for instance "Text". Use hlookup to find
the text based on an index (your value) - and remember to add 1, as the
header is row #1. Then simply concatenate the dlookup results for each
column, add spaces if you need. That'll result in a column with text
that corresponds to your number.
I have a small example spreadsheet here, I can mail you if you're
interested.
Thanks to all. Yes, I thought about using the spreadsheet itself, as
you suggest. The problem is that the resulting text for each line may
be too long and easily visible. Can this be circumvented?
Too long? How much text can each number represent? From my reading,
everything was to fit on one line, so the length would be limited??
Regards
Peter Larsen
