| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Break up my URLs? Can't figure it out...
I have a DB with lots of URLs, "http://www.mysite.com/my-page.html" What i need, is to be able to pull out "http://www.mysite.com" and the ".html" and have the remaining "my-page" remove / replace the dash with a space, so my result is "my page" I can't seem to figure this one out? Please help! -- sunzfan ------------------------------------------------------------------------ sunzfan's Profile: http://www.excelforum.com/member.php...o&userid=34408 View this thread: http://www.excelforum.com/showthread...hreadid=541864 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA Code | Excel Discussion (Misc queries) | |||
| Can't delete a page break | Excel Discussion (Misc queries) | |||
| shortening a forumula | Excel Discussion (Misc queries) | |||
| calculate hours just can't figure it out | Excel Worksheet Functions | |||
| content does not stay in page break | Excel Worksheet Functions | |||
Threaded Mode
