+ Reply to Thread
Results 1 to 2 of 2

Edit/Remove Partial Text in each Row, HOW??

  1. #1
    Registered User
    Join Date
    03-06-2016
    Location
    CityScape, USA
    MS-Off Ver
    365
    Posts
    8

    Edit/Remove Partial Text in each Row, HOW??

    I am very new to Excel so please excuse the limited knowledge of asking this question within this community.


    I have a Column that contains websites in each row. I need to remove ALL details except the final domain.

    Basically, only need domain data AFTER the following phrase: url=

    Some ROWs include the WWW while others simply have the domain. Note. Each ROW is different domain, the only element the same is the url=

    Here is examples. note: I have changed the domain/url to respect the privacy.

    COLUMN A:

    A1: http://www.originalsource.com/goto.p...w.domain1.com; (only need www.domain1.com)

    A2: http://www.originalsource.com/goto.p...w.domain2.com;
    (only need www.domain1.com)

    A3: http://www.originalsource.com/goto.p...rl=domain3.com
    (only need domain3.com

    etc


    I look forward to your reply and thank you in advance for your feedback.

    Please try to keep the answers very detailed (step by step) because of my limited excel knowledge.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2505 Win 11
    Posts
    24,738

    Re: Edit/Remove Partial Text in each Row, HOW??

    Your URLs have been truncated.

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachements to open the upload window.

    View Pic
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Remove partial text from cell
    By shawnoot in forum Excel General
    Replies: 2
    Last Post: 07-13-2014, 11:33 PM
  2. [SOLVED] remove partial text from cell
    By D Casten in forum Excel General
    Replies: 6
    Last Post: 07-13-2014, 11:11 PM
  3. [SOLVED] Match partial text when partial text is not exact
    By NamiSama in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-21-2014, 07:18 PM
  4. Remove partial text from 1 column?
    By IsabellaLearning in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2014, 04:06 AM
  5. remove duplicates based on partial text match
    By smelkin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-16-2011, 09:45 AM
  6. matching partial text within one cell to partial text within another
    By Solstice in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-03-2010, 09:13 PM
  7. Remove partial text from drop down list
    By excel1969 in forum Excel General
    Replies: 6
    Last Post: 10-12-2009, 05:00 AM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1