» 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:
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- Windows XP Pocket Reference
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Financial Peace: Revisited
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
No comments have been submitted.
