LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default find a variable text string

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to convert a month to a quarter ...... Epinn New Users to Excel 26 May 3rd 23 07:45 PM
Find $ in a string of text and return numbers Craig Excel Discussion (Misc queries) 5 September 13th 06 10:42 PM
List File Properties - Author SS Excel Worksheet Functions 1 June 23rd 06 04:56 PM
Find last occurance of text in range farutherford Excel Worksheet Functions 5 August 30th 05 02:00 AM
Find text string in column? Dave Peterson Excel Discussion (Misc queries) 3 August 26th 05 01:22 AM


All times are GMT +1. The time now is 08:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"