TIFFSTER2001
Board Regular
- Joined
- Aug 23, 2004
- Messages
- 71
- Office Version
- 365
I have data that generates in this format T/12345/P0 that need to be turned into this format (T00025089P5), and always has 11 characters. The middle number (12345) is called the group. The group can be anywhere from 1-10000 but zeros need to be added before the group to get to the 11 characters as in this example, T00025089P5. What formula can be used to always create the 11 characters?