Q. I have several product numbers that each appear in a single cell in Excel. Each product number contains the product line (the first three digits), the product color (the middle four digits), and ...

If you would like to follow along in using these functions, you can download this Excel workbook and view the video at the ... the end of the text string and go backward, from right to left, ...

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 ...