Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
locating numbers in a text string
Sub Tester11()
Do While Not IsEmpty(ActiveCell) sStr = ActiveCell.Text x = 0 For i = 1 To Len(sStr) sChr = Mid(sStr, i, 1) If Asc(sChr) = 48 And Asc(sChr) <= 57 Then x = x + 1 ActiveCell.Offset(0, x).Value = i End If Next ActiveCell.Offset(1, 0).Select Loop End Sub should do what you describe. -- Regards, Tom Ogilvy mcdowell wrote in message ... I am attempting to sepatate a single string of characters which includes a middle sector of numbers beginning and ending at different points. The procedure needs to analyze the current cell.... consider each character (loop using LEN(Xcell)) compare the character to see if it = "O" thru "9" .. then place the numeric location point of the character in a cell in the same row using an ActiveCell.Offset(0,x) reference. If multiple numeric characters are found in each string then entries need to be made in adjoining columns offset from the ActiveCell. The procedure needs then to drop to the line below and perform the process again. I have tried every thing I know to create a Sub... using nested loop etc... and I'm baffled.... any help out here?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I EXTRACT NUMBERS FROM TEXT STRING | Excel Discussion (Misc queries) | |||
Convert numbers to text string | Excel Discussion (Misc queries) | |||
Formula Text String: Formatting Text and Numbers? | Excel Discussion (Misc queries) | |||
combining text and numbers in a string | Excel Worksheet Functions | |||
EXTRACT NUMBERS FROM TEXT STRING | Excel Worksheet Functions |