navinrb
Board Regular
- Joined
- Jun 9, 2020
- Messages
- 82
- Office Version
- 2019
- Platform
- Windows
- Mobile
- Web
I have huge list of data with letters and numbers together. I want to filter out wrong formatted data.
For example my correct format is PND123DH and wrong format is pnd123dh.
So basically i mean correct data format is with uppercase & numbers.
How can i do this with formula or any other methods like logical test and filtering out false results.
Thanks in advance .
For example my correct format is PND123DH and wrong format is pnd123dh.
So basically i mean correct data format is with uppercase & numbers.
How can i do this with formula or any other methods like logical test and filtering out false results.
Thanks in advance .