Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need help using the search and replace functions. I need to find a
12 character long string of numbers within a text string. The problem is that the location of the 12 character string is not always the same within the whole text string and string is different in nearly every instance. the only constants are that it is 12 characters long, where every character ranges from 0 to 9 and the string is always preceded and followed by a space character. I was trying to use wildcards to search for any 14 character string beginning and ending with ^w (whitespace) which can be done in WORD but evidently not in excel, Alternativley i tried to search for a 12 character string made up only of characters 0,1,2,3, etc. but came up empty. any help is appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to convert a month to a quarter ...... | New Users to Excel | |||
Find $ in a string of text and return numbers | Excel Discussion (Misc queries) | |||
List File Properties - Author | Excel Worksheet Functions | |||
Find last occurance of text in range | Excel Worksheet Functions | |||
Find text string in column? | Excel Discussion (Misc queries) |