Excel Archives - Sion IT

Archive for the ‘Excel’ Category

Remove spaces from a cell in Excel

I use Excel a lot to manipulate raw text data.  One thing I need to do often is remove spaces from a cell, here are 2 approaches you can use:

Posted on August 5, 2012 at 19:21 by simon · Permalink · One Comment
In: Excel

Excel Tips & Tricks

I use Excel a lot.  Though not in the way that most people will use it.  Excel is a very powerful tool when it comes to text manipulation and working in IT I often have to wade through, process, manipulate, squeeze, expand or turn upside various huge text or csv files.  So here are a few Excel […]

Posted on July 13, 2012 at 7:18 by simon · Permalink · Leave a comment
In: Excel · Tagged with: , , , ,