+ Reply to Thread
Results 1 to 3 of 3

Substitute Formula

  1. #1
    AmyD
    Guest

    Substitute Formula

    I need to create a formula which will allow me to substitute/delete text that
    appear in numbers. ie HKD-2,500.00 or YEN-2,500.00. I have used the
    substitute formula but it will only delete one of the text's specified but I
    want it to pick one or the other
    ie HKD/YEN. Can the substitute formula be nested if so how?

  2. #2
    Ron Coderre
    Guest

    RE: Substitute Formula

    Could you, instead, just return the number after the dash?:
    A1: HKD-2,500.00
    B1: =--MID(A1,FIND("-",A1)+1,255)
    (returns 2500)


    Does that help?

    ***********
    Regards,
    Ron

    XL2002, WinXP-Pro


    "AmyD" wrote:

    > I need to create a formula which will allow me to substitute/delete text that
    > appear in numbers. ie HKD-2,500.00 or YEN-2,500.00. I have used the
    > substitute formula but it will only delete one of the text's specified but I
    > want it to pick one or the other
    > ie HKD/YEN. Can the substitute formula be nested if so how?


  3. #3
    Stefi
    Guest

    RE: Substitute Formula

    =SUBSTITUTE(SUBSTITUTE(A1,"YEN",""),"HKD","")
    if you mean this!

    Regards,
    Stefi

    „AmyD” ezt *rta:

    > I need to create a formula which will allow me to substitute/delete text that
    > appear in numbers. ie HKD-2,500.00 or YEN-2,500.00. I have used the
    > substitute formula but it will only delete one of the text's specified but I
    > want it to pick one or the other
    > ie HKD/YEN. Can the substitute formula be nested if so how?


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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