» Finding the Relative Position of Numbers within a String
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
Problem: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:
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- Writing Excel Macros with VBA, 2nd Edition
- Learn MS Excel 2002 VBA/XML Programming
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
- Microsoft Office XP Introductory Concepts and Techniques
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
No comments have been submitted.
