Hi,
I've been struggling with a formula all afternoon, and am in desperate need of help for my own sanity.
I have a workflow system which automatically generates references. The system will generate a reference which is always prefixed "GOC-" and then will be followed by 6 numbers.
The...