muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all...
how to make custom number format for like this:
how to make custom number format for like this:
data | after formula |
MHFJB8EM6G1011862 | MHF-JB8-EM6-G-1011862 |
MHFE2J2JCK033589 | MHF-E2J-2JC-K-033589 |
criteria : 3 digits from left in twice then digits 10th any help, thank in advance .sst |