R
RWN
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.
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.