Hi Rascl,
“This operation cannot be
completed because of dialog or database engine failures”
This often indicates that the MDAC (Microsoft Data Access) on the
machine needs to be updated. You IT folks should understand what that
means :-)
Apparently my formulas do not recognize the values from the columns
using the text function either.
2. Use the TEXT function ("around" the current formula) to explicitly
format the result as text. In my experience, Word respects that.
In an earlier message you said you had one column where you couldn't use
"Text to columns" because the column contains a formula. Could you
please copy that formula from Excel's formula bar and paste it into your
reply?
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail :-)