If the double dashes only appear at the front of those "formulas", maybe just a
mass change:

Edit|replace
what: =--
with: '-- (apostrophe, dash, dash)
replace all

=======
Depending on how you're bringing them into excel (Opening a .txt file maybe).
You can specify Text as the field type in the data import wizard.



RWN wrote:

Downloaded a file that has certain fields containing leading "--" values.
Excel treats some, but not all(?) as a formula and gives a #NAME error.
I understand its interpretation of the dashes-although I've never used them-and why it
results in the error.
I am looking for a way to eliminate them and retain the text in the field.
An example is;
Dl'd value of --AGCY NOT NUMERIC XXXXXXXXX, results in;
=--AGCY NOT NUMERIC XXXXXXXXX
XL inserts the "=" sign and results in the Name error.

Strangely, it is not consistent throughout, for ex;
"--AGCY NOT NUMERIC 04041011"
is OK. The only difference being that the 1st example has "X's in the field whereas the
second has numbers(?)

At the end of the day I'd like to retain the text value following the dashes.

--
Regards;
Rob
------------------------------------------------------------------------

--

Dave Peterson