How-To Geek on MSN

I stopped using spaces to align Excel cells—and it changed everything

Spacebar alignment breaks when columns, fonts, or layouts change, but Excel's custom number formatting keeps everything ...
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 ...