Hi...
I have a field that looks like this:
489C
It's defined as a 6 char field, so it's actually '489C '. I want to make it ' 489C'. Help me with a formula to do this. I don't want to just do it in the formatting because I want to use ' 489C' in another formula. I know this isn't hard, but I'm going in circles.
Thanks!!
I have a field that looks like this:
489C
It's defined as a 6 char field, so it's actually '489C '. I want to make it ' 489C'. Help me with a formula to do this. I don't want to just do it in the formatting because I want to use ' 489C' in another formula. I know this isn't hard, but I'm going in circles.
Thanks!!