Special Paste Error...Data pastes into one column

[Guest]

I have this problem with a couple of my computers here on site. I will copy
some information from database that is web based and I will paste it using
Special Paste, Select text and OK. Now it will normally paste the data into
individual columns, but in this case it will paste all of the data into one
column. I will go to another computer pull the data from the same page and
special paste it. It will correctly paste it into their own individual
columns. Any clues... Thanks...

 

[Jim Rech]

Excel normally pastes without parsing but if, in the current Excel session,
there are been a parsing into column with the Text Import Wizard (or Data,
Test to Columns) then paste parses the same way.

When you do not get the parsing you want you should just select the range of
data and do a Data, Text to Columns, picking your delimiter, etc. You'll
probably find that further pastes during that Excel session parse
automatically.

--
Jim
|I have this problem with a couple of my computers here on site. I will
copy
| some information from database that is web based and I will paste it using
| Special Paste, Select text and OK. Now it will normally paste the data
into
| individual columns, but in this case it will paste all of the data into
one
| column. I will go to another computer pull the data from the same page
and
| special paste it. It will correctly paste it into their own individual
| columns. Any clues... Thanks...