Results 1 to 6 of 6

Split to new rows and delete some characters for webiste

Threaded View

  1. 02-22-2017, 05:45 AM #1
    wilsonwilson4
    wilsonwilson4 is offline
    Registered User
    Join Date
    04-11-2014
    Location
    Australia
    MS-Off Ver
    Excel 2003, 2010, 2013
    Posts
    33

    Split to new rows and delete some characters for webiste

    Hi All excel expert

    I am wondering if anyone can help me for the VBA for data attached?

    I am still learning but find it hard to create efficient as I deal with large data.

    The problem is I would like to split any website link that has 2 or three in same row and move to next row and copy the rest.
    In addition, I also want to know if there is any formula for get rid http:\\www. and character after "/". Probably my explanation not good but I attached the example and result.
    I tried to use Left but cannot be done.

    Thank you

    Wilson
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] DELETE ROWS WITH FOREIGN CHARACTERS/Words (e.g Chinese & Arabic)
    By thalyn_yang in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-16-2016, 06:13 AM
  2. delete rows that have three or more characters
    By stephme55 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-11-2016, 08:56 PM
  3. Need Macro code to split data split in 7 sheets based on variable rows in column A
    By Alija_21 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-31-2015, 08:03 AM
  4. [SOLVED] Delete rows where the column are given the less than X characters
    By nlyrk0 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-13-2015, 09:06 AM
  5. [SOLVED] Delete characters and add * in front and last characters in ACCESS QUERY
    By LALTIZER in forum Access Tables & Databases
    Replies: 9
    Last Post: 02-01-2013, 02:06 PM
  6. [SOLVED] Split long text with max 30 characters keeping words intact to multiple rows using vb
    By newbi004 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-10-2012, 04:36 PM
  7. Delete special characters in 1 column but in multiple rows
    By fnjtravel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2011, 03:31 PM

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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1