G
Guest
(This is all occuring at a data lab in a customer's office, so I really don't
know what OS or version of Office - I'm guessing OS is 2003 and Office is 2K
- or the type of app the data is coming from. Also, there's no telling what
any of the last 50 users of that PC may have changed over the last week).
I have a user copying data from the customer's proprietary data mining
application into Excel. Usually this is seamless and the data pops right
into the correct columns. This time, though, each row of data is pasting
into 1 column, with a box thrown in as a column delimiter.
If it was just using semi-colons or similar, I could easily text-to columns
it to get it right, but I can't figure a way to use these boxes as the
delimiter in the wizard.
We have tried re-starting Excel, but want to avoid re-booting since the data
mining took over 3 hours and we don't want to do that again.
Any suggestions? I figure there must be a setting somewhere...
Thank you!
Erin
know what OS or version of Office - I'm guessing OS is 2003 and Office is 2K
- or the type of app the data is coming from. Also, there's no telling what
any of the last 50 users of that PC may have changed over the last week).
I have a user copying data from the customer's proprietary data mining
application into Excel. Usually this is seamless and the data pops right
into the correct columns. This time, though, each row of data is pasting
into 1 column, with a box thrown in as a column delimiter.
If it was just using semi-colons or similar, I could easily text-to columns
it to get it right, but I can't figure a way to use these boxes as the
delimiter in the wizard.
We have tried re-starting Excel, but want to avoid re-booting since the data
mining took over 3 hours and we don't want to do that again.
Any suggestions? I figure there must be a setting somewhere...
Thank you!
Erin