Results 1 to 5 of 5

Thread: Remove Parts to URL

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 02-19-2016, 03:20 PM #5
    Rick Rothstein
    Rick Rothstein is offline
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    14
    Quote Originally Posted by snb View Post
    Code:
    Sub M_snb()
   Columns(1).Replace "*www.", ""
   Columns(1).Replace "*://", ""
End Sub
    You forgot to remove trailing slash if there is one.
    Last edited by Rick Rothstein; 03-14-2016 at 05:15 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Lookup First URL From Google Search Result Using VBA
    By joparo in forum Excel Help
    Replies: 30
    Last Post: 04-15-2019, 07:36 PM
  2. add hyperlink with the URL hardcoded in the code
    By saidineshbabu in forum Excel Help
    Replies: 2
    Last Post: 11-03-2013, 05:26 AM
  3. Opening URL @ new tab in Internet Explorer: VBA
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 09-11-2013, 08:22 PM
  4. Excel Formula To Distribute An Amount To Different Parts With Different Limits
    By excel_learner in forum Excel Help
    Replies: 12
    Last Post: 07-31-2013, 05:44 PM
  5. Import html source of url list in each cell
    By Sergio Alfaro Lloret in forum Excel Help
    Replies: 8
    Last Post: 07-31-2012, 03:03 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules