Results 1 to 7 of 7

Thread: Pull text from the left of a character to the right of the next character foun

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Member
    Join Date
    Jul 2012
    Posts
    55
    Rep Power
    14
    Hi,

    Give us more examples.
    With given examples, use one of the following formulas:

    =SUBSTITUTE(RIGHT(A1,LEN(A1)-FIND("-",A1)+1),"^","")
    or
    =SUBSTITUTE(RIGHT(A1,5),"^","")

  2. #2
    Junior Member
    Join Date
    Jan 2016
    Posts
    3
    Rep Power
    0
    Quote Originally Posted by Ingolf View Post
    Hi,

    Give us more examples.
    With given examples, use one of the following formulas:

    =SUBSTITUTE(RIGHT(A1,LEN(A1)-FIND("-",A1)+1),"^","")
    or
    =SUBSTITUTE(RIGHT(A1,5),"^","")

    aab*532*.3*apple^
    aaac*53268*.598*-car^
    george*ford*678*banana^
    rifle*car*.705*@exclamation^

    results would need to be:

    apple
    -car
    banana
    @exclamation

  3. #3
    Member
    Join Date
    Jul 2012
    Posts
    55
    Rep Power
    14
    OK.

    Try this formula:

    =SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(A1,"*",REPT(" ",50)),30)),"^","")

    or

    =TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(A1,"^",""),"*",R EPT(" ",50)),30))
    Last edited by Ingolf; 01-07-2016 at 12:50 AM.

Similar Threads

  1. Replies: 4
    Last Post: 08-11-2015, 02:14 PM
  2. Macro To Delete Numbers With Trailing Character
    By Howardc in forum Excel Help
    Replies: 8
    Last Post: 04-05-2013, 08:14 PM
  3. Left and Right Mouse Click Event
    By PcMax in forum Excel Help
    Replies: 10
    Last Post: 11-24-2012, 04:54 AM
  4. Count words having more than one character in a cell
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 3
    Last Post: 03-13-2012, 08:29 PM
  5. Replies: 2
    Last Post: 02-29-2012, 08:24 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •