HowToGeek on MSN

How to Automatically Fix Column Width to Fit Your Data in Excel

There are numerous ways to change column widths in Excel, but did you know you can force Excel to do this automatically when ...
JournalofAccountancy

Using TEXTSPLIT to dissect Excel text strings

Q. I have used the Excel functions LEFT, MID, and RIGHT to dissect cells. However, I have some spreadsheets where each piece of information is a different length and uses different delimiters. Is ...