Forum Discussion

NeveLeem's avatar
NeveLeem
Qrew Trainee
8 years ago

Formula to change one letter in a text field

Hello!

I have a text field. This text field will always have "XXXX-XXXX" format, unless there is a revision to the document. In which case, it will turn into "XXXX-XXXX 01"

I was wondering if there is a formula to turn that "0" to "R", to signify revision status, without changing other "0"s?

This "0" will always be in the same 11th spot. 


Thank you for all of your help!
  • ChrisChris's avatar
    ChrisChris
    Qrew Assistant Captain
    8 years ago

    [altered field] = formula text =

    Left([field],10)&"R"&Right([field],1)

    • NeveLeem's avatar
      NeveLeem
      Qrew Trainee
      8 years ago
      I had to alter it slightly, but this theory worked. Thank you!