Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Stripping digits from a column
Hi,
I've a column containing alphanumeric text as 200731705A832565410B12345678. Out of this text, I need only the 9 right most digits. How do I go by? TIA, Mark |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Stripping digits from a column
Assuming the text is in cell A1, type =RIGHT(A1,9)
If this doesn't work, the text may contain non-printing characters. If so, type =RIGHT(CLEAN(C9),9) Hope this helps. -- BernieG "Mike" wrote: Hi, I've a column containing alphanumeric text as 200731705A832565410B12345678. Out of this text, I need only the 9 right most digits. How do I go by? TIA, Mark |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Stripping digits from a column
If yu have a set of mixed numbers and letters and want only the nine-most
numbers, then: =RIGHT(returnnumerals(A2),9) where the UDF is: Public Function ReturnNumerals(rng As Range) As String Dim sStr As String, i As Long, sStr1 As String Dim sChar As String sStr = rng.Value For i = 1 To Len(sStr) sChar = Mid(sStr, i, 1) If sChar Like "[0-9]" Then sStr1 = sStr1 & sChar End If Next ReturnNumerals = sStr1 End Function -- Gary''s Student - gsnu200770 "BernieG" wrote: Assuming the text is in cell A1, type =RIGHT(A1,9) If this doesn't work, the text may contain non-printing characters. If so, type =RIGHT(CLEAN(C9),9) Hope this helps. -- BernieG "Mike" wrote: Hi, I've a column containing alphanumeric text as 200731705A832565410B12345678. Out of this text, I need only the 9 right most digits. How do I go by? TIA, Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to customize number to 10 digits including 2 digits after deci | Excel Worksheet Functions | |||
Remove first few digits from all cells in the column | Excel Worksheet Functions | |||
Delete first two digits in column | Excel Worksheet Functions | |||
How to set a column to accept only a specified number of digits | Excel Worksheet Functions | |||
Stripping time in Pivot Table Column Header | Excel Worksheet Functions |