Bishoptrue
New Member
- Joined
- Jan 4, 2019
- Messages
- 2
Hello folks, here is what I am trying to do. I have a column of numbers like this:
091215421R
And I need each cell in the column to be formatted like this:
Q09-1215421
There are always 10 characters in the original cell. The last character may be anything but needs to be dropped. A capital Q must be inserted at the beginning, and a hyphen as the fourth character after the Q and the fist two numbers.
Is this possible? Thank you in advance for your kind consideration.
091215421R
And I need each cell in the column to be formatted like this:
Q09-1215421
There are always 10 characters in the original cell. The last character may be anything but needs to be dropped. A capital Q must be inserted at the beginning, and a hyphen as the fourth character after the Q and the fist two numbers.
Is this possible? Thank you in advance for your kind consideration.
