You didn't mention exactly which formulas you went with, but just click on
the fill handle, and drag down to copy as far as needed.
If you have a very large column of data (UPC codes), you could easily have
XL automatically copy the formula for you.
If you *double click* the fill handle on the cell containing the formula, it
will *automatically * be copied down the column, as far as there is any data
in the adjoining column, left *or* right.
If it happens to be between 2 columns of pre-existing data, the length of
the column on the left takes precedence.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
Okay awesome. Thanks so much for the help guys. I went with some hidden
cells to insert the extra parts of the formula. Now, is there a way to
make it apply to each and every field in Column A? and Column B?
Thanks!
