Vincent88
Active Member
- Joined
- Mar 5, 2021
- Messages
- 382
- Office Version
- 2019
- Platform
- Windows
- Mobile
How and what is the best way to unify the inputs of a cell (ie "A2") : There will probably be three type of inputs
123456
req%123456
req000000123456
but I want to this cell ("A2") to turn these inputS to one single format REQ000000123456 (add REQ000000 to the last six digits of input)
I only know to formate 123456 in FORMAT CELLS / CUSTOM but no knowledge to tackle the other two !
Should I create a marco for this ?
123456
req%123456
req000000123456
but I want to this cell ("A2") to turn these inputS to one single format REQ000000123456 (add REQ000000 to the last six digits of input)
I only know to formate 123456 in FORMAT CELLS / CUSTOM but no knowledge to tackle the other two !
Should I create a marco for this ?