Quote:
Originally Posted by amonkie
I didn't know about the Excel Addict but I'm in excel every day for my job.
I usually prefer the Text to Columns approach as I export large amounts of raw data from our database, and sometimes the formatting is different each time. So rather than try to set up formulas, I can set the parameters to catch either by comma, or fixed width. These seem to work for 95% of the data formatting.
|
I tend to go the other way - because you can add new data and drag the formulae to extend the aproach. Most of my excel work is about solving problems that will come round again, and I have been bitten in the arse before by solving a problem the "quick" way today, only to have the same query come back later. I tend to find that (quick * 2) > (slow).