Search for number after specific text in string
Hi Mike Thanks for the response, I can see what you are suggesting,
unfortunately I didnt give you enough information as there are numeric
characters prior to the specific numeric I am looking for
This is a sample of the complete string :
\\ntf01\projects\Programme Plans\WAN\WAN.mpp\21,\\ntf01\projects\Programme
Plans\WAN\WAN ADC Plan.mpp\5
The specific number I am looking for here is 21 as it is the first numeric
after .mpp\
The string could also look like this :
\\ntf01\projects\Programme Plans\WAN\WAN.mpp\21
And again I would look for the 21
"Mike H" wrote:
Hi,
There are several ways of doing this so lets start with these
=MID(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456 789")),LEN(A1))
or
=LOOKUP(99^99,--("0"&MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0 123456789")),ROW($1:$10000))))
Mike
"AMH" wrote:
I want to search for a number after a specific piece of text in a string, the
number can be 1 to 4 characters in length and will finish with either a comma
or a space, format like this :
.mpp\????, or .mpp\???? (with the question marks being numeric between 1
and 9999)
Any help would be much appreciated
|