|
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.
__________________
Calling from deep in the heart, from where the eyes can't see and the ears can't hear, from where the mountain trails end and only love can go... ~~~ Three Rivers Hare Krishna
|