+ Reply to Thread
Results 1 to 4 of 4

Deleting specific characters in cells

  1. #1
    Registered User
    Join Date
    08-20-2013
    Location
    Weston, CT
    MS-Off Ver
    Exel 2010
    Posts
    2

    Deleting specific characters in cells

    I have a list of URL's. Some of these URL's have a slash at the beginning and/or the end, so they look like either this: ibm.com/ or this: /ibm.com/ or this: /ibm.com

    What I need is a formula that will delete all of these slashes and make the text in the cell look like this:

    ibm.com

    It also has to leave all of the other records intact, as many of the entries are already clean.

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Deleting specific characters in cells

    Try the substitute function

    =SUBSTITUTE(A1,"/","")

  3. #3
    Registered User
    Join Date
    08-20-2013
    Location
    Weston, CT
    MS-Off Ver
    Exel 2010
    Posts
    2

    Re: Deleting specific characters in cells

    The problem is that some of the URL's are listed as something like this-- ibm.com/index

    in which case the slash in the middle needs to stay there. Wouldn't the formula you provided get rid of these slashes as well?

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,658

    Re: Deleting specific characters in cells

    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

+ 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. Deleting Specific Data in Specific Cells
    By emily8134 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-18-2013, 10:51 AM
  2. Deleting cells based on number of characters in a word
    By donaldc88 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-07-2012, 09:48 PM
  3. Deleting specific characters
    By adon_joey in forum Excel General
    Replies: 1
    Last Post: 02-24-2011, 02:17 PM
  4. Replies: 2
    Last Post: 06-17-2010, 08:39 AM
  5. [SOLVED] find cells that contain specific characters
    By mshornet in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-23-2005, 10:10 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1