Hi Everyone,
This is my very first post here and was wondering if anyone can help me. I have a large excel sheet that lists various URLs and i need to be able to extract the numbers from the URLS in each cell.
Can anyone please help me do this?? please see attached screen print for further detail..
If you know how to do this can you please email me on info @boardriders.co.uk
one way providing all numbers are 7 digits long is to use
where a1 is cell with url in=MID(A1,FIND(".htm",A1)-7,7)
Last edited by martindwilson; 06-30-2008 at 02:17 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks