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??
I was not surely enough clear and I am sorry because of that. Each number may represent strings with 30 characters, and I may have more X variables. Paul
