Extract 2, 3, 4 or 5-digit number from string
 

I have a list of URLs where some contain the parameter "categoryid="
with either a 2, 3, 4, or 5 digit number. I need to extract that
number, as an integer, into a neighboring column. I need a routine or
function to help with this - something along the line of making the mid
function smart enough to recognize numbers and adjust the length value
so it only takes the numbers. And if it doesn't find "categoryid",
then leave the cell blank.

TIA,
Jim

Extract 2, 3, 4 or 5-digit number from string
 

Assuming the URL's are in Column A beginning in A1 put in this formula using
Ctrl+Shift +Enter to enter it rather than just enter since it is an array
formula. Then drag fill down the column.

=IF(ISNUMBER(FIND("categoryid=",A1)),MAX(IF(ISNUMB ER((MID(A1,FIND("categoryi
d=",A1)+11,{1,2,3,4,5}))*1),(MID(A1,FIND("category id=",A1)+11,{1,2,3,4,5}))*
1,"")),"")



--
Regards,
Tom Ogilvy

"Jim" wrote in message
ups.com...
I have a list of URLs where some contain the parameter "categoryid="
with either a 2, 3, 4, or 5 digit number. I need to extract that
number, as an integer, into a neighboring column. I need a routine or
function to help with this - something along the line of making the mid
function smart enough to recognize numbers and adjust the length value
so it only takes the numbers. And if it doesn't find "categoryid",
then leave the cell blank.

TIA,
Jim

Extract 2, 3, 4 or 5-digit number from string
 

Many thank, Tom.

Jim