Replace value in formula

  • i have a string "251423,a" in cell A2. The formula in cell C2=A2. except for in C2 i want the value to read "251423.a" instead of the ",." the string is not always the same length. so really what i need to replace the ",' with a ".' in a formula.


    thanks for your help.

  • Re: Replace value in formula


    This formula should work (provided there will always be only one comma in the cell):

    =REPLACE(A2,FIND(",",A2),1,".")


    Brian

    >DISABLE DALEK WITH SONIC SCREWDRIVER
    The batteries have gone flat. I told you that you should have changed them after you spent ten hours debugging it in the TARDIS. But did you listen? Noooooooo...


    The Dalek notices your presence for the first time, and reacts normally.
    "EXTERMINATE! EXTERMINATE!"


    *** You have been exterminated ***

  • Re: Replace value in formula


    I bow before norie's superior and simpler solution. :)

    >DISABLE DALEK WITH SONIC SCREWDRIVER
    The batteries have gone flat. I told you that you should have changed them after you spent ten hours debugging it in the TARDIS. But did you listen? Noooooooo...


    The Dalek notices your presence for the first time, and reacts normally.
    "EXTERMINATE! EXTERMINATE!"


    *** You have been exterminated ***

  • Re: Replace value in formula


    NORIE was the winner - worked like a charm i knew there was an easy fix. thanks for your help!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!