» 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:
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
- Special Edition Using Microsoft Word 2002
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
No comments have been submitted.
