Hello;

(Sorry for cross-posting, but no expert has taken it on from the other XL
forum, suggesting the answer is either too simple or too difficult or simply
can't be done using w/s functions/macro!)

1) This exercise would save me considerable time and would almost certainly
eliminate the possibility of typing errors in preparing the input data file
for another application (program).

2) My program requires each input multivariant polynomial equation to be
specified as follows and in the same order:
--Number of Independent Variables, N (max 10)
--Number or Terms, M (max 20)
--Term 1: power of var 1
: power of var 2
: ...................
: power of var N
: coeff
--Term 2: power of var 1
: power of var 2
: ...................
: power of var N
: coeff
.....................................
--Term M: power of var 1
: power of var 2
: ...................
: power of var N
: coeff

3) It would be extremely helpful if I could type (or cut/paste) the equation
(of up to 10 variables and up to 20 terms) in a cell on a w/s and
automatically get the above particulars extracted and nicely tabulated in a
column.

4) Simplified Example: (3 var & 4 terms)
cell B1 enter :: 1.5*X + 2.*X*Y^2 - 3.0*Z*Y + 4.5*X*Z^4 = 0.0
cell B2 enter no. of variables :: 3
cell B3:B3+N-1 enter var names :: X Y Z

Expected Results:
Number of Terms M, cell C5 :: 4
Term 1: power of var 1, cell C6 :: 1
: power of var 2, cell C7 :: 0
: power of var 3, cell C8 :: 0
: coeff , cell C9 :: 1.50
Term 2: power of var 1, cell C10 :: 1
: power of var 2, cell C11 :: 2
: power of var 3, cell C12 :: 0
: coeff , cell C13 :: 2.00
Term 3: power of var 1, cell C14 :: 0
: power of var 2, cell C15 :: 1
: power of var 3, cell C16 :: 1
: coeff , cell C17 :: -3.00
Term 4: power of var 1, cell C18 :: 1
: power of var 2, cell C19 :: 0
: power of var 3, cell C20 :: 4
: coeff , cell C21 :: 4.50

Could someone please provide some guidance on how to accomplish that ??

Thank you kindly.