Formula to change one letter in a text field

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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!
Photo of Neve

Neve

  • 260 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb

[altered field] = formula text =

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

Photo of Neve

Neve

  • 260 Points 250 badge 2x thumb
I had to alter it slightly, but this theory worked. Thank you!