Search for number after specific text in string
Thanks guys Mike's solution worked
"Teethless mama" wrote:
Try this:
=TRIM(MID(SUBSTITUTE(A1,",",REPT("
",99)),SEARCH("mpp\",SUBSTITUTE(A1,",",REPT(" ",99)))+4,99))
"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
|