On Sun, 20 Aug 2006 12:53:02 -0700, JayW
wrote:

Ron,

I downloaded the morefunc.xll as you suggested. Works perfectly and very
simple to use.

As a relatively new user of Computers, I must thank you and Toppers for
taking the trouble to respond.

This may be another question (if so I will create a new thread), but is
there a way of creating a new Worksheet using the values in the new
cells/columns containing the absolute text & figures without the functions

--
JayW, New Milton, Hants, UK

Well, you can

1. Insert/Worksheet
2. On the old worksheet (with the formulas) select the range, then Edit/Copy
3. Navigate to the new worksheet
Select the upper left corner of the range
Edit/Paste Special/Values

The above can be automated via a macro, if you need to do this repeatedly.
--ron