Forum Discussion
Custom Number Formatting
Good day folks! I want to create a custom format to assign to a group of cells. Thank you in advance. Mister Bob the Tomato I want to make entries in these two manners: D032CR20123456 and C07CR2...
Here is an example with a formula.
There are many ways and ways to get there, that's just one of the many.
Formula: =MID(A1,1,1)&"-"&MID(A1,2,3) &"-"&MID(A1,5,2) &"-"& MID(A1,7,2)&"-"&MID(A1,9,6)
Result: D-032-CR-20-123456
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.