How-To Geek on MSN

How to Use the VALUE Function in Microsoft Excel

Excel's VALUE function has only one argument: where a is the value stored as text that you want to convert into a number. This can be hard-coded inside double quotes or a reference to a cell ...
JournalofAccountancy

Using TEXTSPLIT to dissect Excel text strings

I have used the Excel ... of text strings? A. TEXTSPLIT is a very useful function for breaking down text cells that contain different lengths of text and delimiters. It can be used in several ways, ...