» Finding the Relative Position of Numbers within a String
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
List1 (column A) consists of strings composed of numbers and characters.
Numbers may appear at the beginning or the end of the string, but not in the middle.
For each of the strings, we want to determine whether the numbers appear at the beginning or the end.
Solution:
Use the ISNUMBER, RIGHT, and LEFT functions as shown in the following formula:
=IF(ISNUMBER(-RIGHT(A2,1)),"End",IF(ISNUMBER(-LEFT(A2,1)),"Beginning"))
Book Store:
Recommended Books:
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Wall Street Journal Guide to Understanding Money and Investing
- Microsoft Word Version 2002 Inside Out
No comments have been submitted.
