Separate version type and names

saif178 Posts 1 Registration date Friday March 3, 2017 Status Member Last seen March 3, 2017 - Updated by Ambucias on 3/03/17 at 04:05 AM
I have data on browsers used by users where in I need to separate version type and names. I am struck up in the middle. Formula used by me is =LEFT(F7(MIN(FIND({0,1,2,3,4,5,6,7,8,9},F7&"0123456789")))-1). But its not working for all inputs. Data available is List of browser versions. Output needed is Group the browser versions. For example, Google Chrome 9.0, Google Chrome 9.1 and Google Chrome 9.3 should be grouped under “Google Chrome”. Version => Type: Google Chrome 9.1 => Google Chrome. Google Chrome 9.0 => Google Chrome. Google Chrome 8.0 => Google Chrome. Google Chrome 7.0 => Google Chrome. Google Chrome 6.0 => Google Chrome. Conditions are: Do not pivot the table. Need two columns – Version and Type. You can split the column but the catch is, few versions have numbers in the beginning. Eg: 360 Secure Browser. Please help