+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Remove from right to left up to a first symbol

  1. 07-01-2010, 01:56 PM #1
    emb is offline
    Registered User
    Join Date
    07-01-2010
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Question Remove from right to left up to a first symbol

    Hello,
    I hope someone can help me with this, how do I remove all up to the first symbol “|” from right to left, see examples below

    Examples:

    Shirt|tshirt|small|blue|guess 73653 I want to remove |guess 73653 should look like this Shirt|tshirt|small|blue

    Jacket| leather vans I want to remove |vans should look like this Jacket|leather

    Pants|shorts|size 28|quick silver 534 I want to remove |quick silver 534 should look like this Pants|shorts|size 28

    So from the last “|” everything is removed

    Thank you in advance

    Cheers
    Reply With QuoteRegister To Reply
  2. 07-01-2010, 04:10 PM #2
    DonkeyOte is offline
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Remove from right to left up to a first symbol

    Various routes - one might be:

    =LEFT(A1,FIND("^^",SUBSTITUTE(A1,"|","^^",LEN(A1)-LEN(SUBSTITUTE(A1,"|",""))))-1)

    where A1 holds the original string (assumes strings always contain at least one pipe)
    My Recommended Reading:

    Volatility
    Sumproduct & Arrays
    Pivot Intro
    Email from XL - VBA & Outlook VBA
    Function Dictionary & Function Translations
    Dynamic Named Ranges
    Reply With QuoteRegister To Reply
  3. 07-01-2010, 06:34 PM #3
    emb is offline
    Registered User
    Join Date
    07-01-2010
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Remove from right to left up to a first symbol

    Works great Thank you.......
    Last edited by shg; 07-01-2010 at 06:35 PM. Reason: deleted quote
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1