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 th...
Forum Discussion
[altered field] = formula text =
Left([field],10)&"R"&Right([field],1)
I had to alter it slightly, but this theory worked. Thank you!