Mike-hybrid
Wanderer
Any Excel genius' ?
Ok, so here's the setup.
An Oracle DB has been exported into flat text files, and imported into Excel spreadsheets. The data conversion guys are obviously retarded, as we have a problem with sorting the data in Excel. The total rows are totalling over 650,000 records (phone, contactdate, name, address, city, state, zip, createdate, lastupdate, recruiterassigned, salesassociate, ssn, resumeid). The only problem we are facing right now is an "embedded" apostrophe.
Ok, so first off, obviously the first idea was Find/Replace. Doesnt work. Tried just a find and searched data in cells, formulas, etc. No go. This ' is embedded before EVERY cell's data as of now, making sorting by name, last contact, etc impossible.
Check the attached pic, and if you have any idea a quick way to remove the apostrophe and would like to earn 500k on UOGamers, make a suggestion. Anyone who gets it right receives the 500k.
Here's the pic. Notice rows "O" and "P" are date fields but are to the left of the cell, and row "Q" has been updated by me up until the last 2 cells. Notice the ones that have been fixed sit right (as all date fields do in Excel). Anyway, as of now Im semi-manually removing the ' with EZ Macros, but we are talking about over 2 million cells to update (this macro does like 500 cells per 10 seconds).
So shoot me your ideas, and the winner gets 500k :>
Ok, so here's the setup.
An Oracle DB has been exported into flat text files, and imported into Excel spreadsheets. The data conversion guys are obviously retarded, as we have a problem with sorting the data in Excel. The total rows are totalling over 650,000 records (phone, contactdate, name, address, city, state, zip, createdate, lastupdate, recruiterassigned, salesassociate, ssn, resumeid). The only problem we are facing right now is an "embedded" apostrophe.
Ok, so first off, obviously the first idea was Find/Replace. Doesnt work. Tried just a find and searched data in cells, formulas, etc. No go. This ' is embedded before EVERY cell's data as of now, making sorting by name, last contact, etc impossible.
Check the attached pic, and if you have any idea a quick way to remove the apostrophe and would like to earn 500k on UOGamers, make a suggestion. Anyone who gets it right receives the 500k.
Here's the pic. Notice rows "O" and "P" are date fields but are to the left of the cell, and row "Q" has been updated by me up until the last 2 cells. Notice the ones that have been fixed sit right (as all date fields do in Excel). Anyway, as of now Im semi-manually removing the ' with EZ Macros, but we are talking about over 2 million cells to update (this macro does like 500 cells per 10 seconds).
So shoot me your ideas, and the winner gets 500k :>