» 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:
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Marketing Plan: A Handbook with Marketing Plan
- Special Edition Using Microsoft Office XP
- Windows XP All-in-One Desk Reference For Dummies
- The 11 Immutable Laws of Internet Branding
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
No comments have been submitted.
