Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extracting 7 digit number from alphanumeric string | Excel Discussion (Misc queries) | |||
EXTRACT NUMBER FROM STRING | Charts and Charting in Excel | |||
Change a 1,2,3 or 4 digit number to a 6 character text string | Excel Worksheet Functions | |||
How to extract each digit from a number in one cell? | Excel Discussion (Misc queries) | |||
How to extract the Number from a String | New Users to Excel |