Hello all,

(XL 2003 SP3 on Win XP Pro SP2)

Are there "TextToColumns" properties? If so, are these properties on
individual sheets? Are they on individual cells?

I have 5 SQL scripts run on MS SQL Server (only tested the first 3 so far)
and the results get pasted into XL. Among the results, there are 4 cells
that look something like this:

[Account Type Description] - <$20,000
[Account Type Description] - =$20,000

When I pasted the 1st query's results into the first sheet in XL, the "... -
<$20,000" was all kept in one cell.

But pasting the 2nd & 3rd query's results into the 2nd & 3rd sheet in XL, XL
is recognizing the comma in "... - <$20,000" as a column delimiter for the
"Text to Columns" functionality of XL. So one cell gets "... - <$20", the
next cell to the right ends up being 0 (zero), and then all cells to the
right of that are offset by one cell.

Any ideas as to how I can get around this?

Thanks for any help anyone can provide,

Conan Kelly