Chad Rothschiller, a program manager on the Excel team has written a lengthy article discussing using formulas to 'clean up' data in Excel. It is very indepth and covers these topics
This is the sort of work we are often asked to automate using VBA code. If you regularly need to pull data from text files or from databases and then have to spend time cleaning them up so you can use them in reports or charts then this is a task that can be performed easily by a macro. This can save hours of time each time this task is performed and can really increase your productivity.
Contact us to see how we can provide you with a quote for this sort of work that can show your boss how much time you will save as a result..
Â
Recent comments
10 years 37 weeks ago
10 years 37 weeks ago
10 years 39 weeks ago
10 years 39 weeks ago
10 years 39 weeks ago
10 years 39 weeks ago
10 years 39 weeks ago
10 years 39 weeks ago
10 years 39 weeks ago
10 years 39 weeks ago