Closed Thread
Results 1 to 2 of 2

How do you remove text before the last forward slash?

  1. 05-22-2014, 07:29 AM #1
    lukesmith7
    lukesmith7 is offline
    Registered User
    Join Date
    05-22-2014
    Posts
    20

    How do you remove text before the last forward slash?

    Hey everyone,

    Does anyone know a formula where you can remove all the text before the last forward slash?

    For example; entry: Garden/Shed/Table/Ashtray and I would just like Ashtray!

    Any help would be greatly appreciated, don't really fancy going through 3500 records manually!

    Thanks very much for your time, any help would be greatly appreciated,

    Luke
    Reply With QuoteRegister To Reply
  2. 05-22-2014, 07:31 AM #2
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: How do you remove text before the last forward slash?

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.
    Reply With QuoteRegister To Reply
Closed Thread
« 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. How do you remove all text before the last forward slash?
    By lukesmith7 in forum Excel General
    Replies: 7
    Last Post: 05-22-2014, 07:59 AM
  2. Automatic insert of forward slash (/)
    By Shivas Regal in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-08-2010, 04:27 PM
  3. Converting minus to forward slash = incorrect results
    By danpai in forum Excel General
    Replies: 1
    Last Post: 03-12-2009, 04:08 AM
  4. Forward Slash Problem
    By mortikiv in forum Excel General
    Replies: 3
    Last Post: 11-06-2007, 01:59 AM
  5. formulae for adding a forward slash automatically into a cell
    By angelgrant in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 06-21-2006, 08:35 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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1