sksanjeev786
Board Regular
 Joined
 Aug 5, 2020
 Messages
 150
 Office Version

 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