Hi, Jack. It is not as complicated as you may think.
Your first group should fill down without a problem. It does in my
spreadsheet. The third and fourth groups likewise.
You need to break the second group in two: b001c002 in the first column,
v001 in the second column and, in the third column =Ax & Bx. Fill all
columns down.
Jack Gates wrote:
I have not found any information that will tell me if this can be
done. I have looked on the OpenOffice.org site and followed several
links to other sites with tutorials. I have tried to figure out how
to do it from inside Calc.
This is an example of what I want to do.
b001c001v001
b001c001v002
b001c001v003
b001c002v001
b001c002v002
b002c001v001
b002c001v002
b002c002v001
b002c002v002
I could take several days to enter this one cell at a time for over
1500 cells
the cell column dialog wants to focus on the beginning of the string
and not the end.
OpenOffice.org 2.0.2 on FC5
--
If you're seeking, check out http://www.rci.org.au
An OS gem: http://www.pclinuxos.com/page.php?6
Send instant messages to your online friends http://au.messenger.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
