Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    North Carolina, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copy all to right of $ sign (2007)

    Is there a function similar to left, right, etc. that would allow me to copy all data to the right of the dollar sign?

  2. #2
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts

    Re: Copy all to right of $ sign (2007)

    if the text you are looking for is in Cell A1 then try the following:
    =RIGHT(A1,LEN(A1)-SEARCH("$",A1))
    this should give you the remaining text.

    Tom Duthie

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copy all to right of $ sign (2007)

    Or

    =MID(A1,FIND("$",A1)+1,100)

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Copy all to right of $ sign (2007)

    Or

    =MID(A1,FIND("$",A1)+1,100)*1

    if you want to ensure the result stays a value so you can calculate with it.
    Regards,
    Rudi

Posting Permissions

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