Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
(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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Row Expansion | Excel Worksheet Functions | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |