sksanjeev786
Well-known Member
- Joined
- Aug 5, 2020
- Messages
- 873
- Office Version
- 365
- 2016
- Platform
- Windows
Hi Team,
I have data in various formate. can I get any formula to find only data. There will be % space on random data but I need only data i.e 32 data can be in single digit as well. (instead of 32 it can be 8 with all below condtion)
32%A, (%)
32%ab,
32AB, (No Space )
32 AB(only has Space)
Thanks in Advance.
Regards,
Sanjeev
I have data in various formate. can I get any formula to find only data. There will be % space on random data but I need only data i.e 32 data can be in single digit as well. (instead of 32 it can be 8 with all below condtion)
32%A, (%)
32%ab,
32AB, (No Space )
32 AB(only has Space)
Thanks in Advance.
Regards,
Sanjeev