I have 200 rows of data for a software title of different Editions and versions. In order to report on the number of installs for each edition and version, I would like to extract the version up to the first number after the first decimal. However, I have text strings that seem to have only the " - " in common. Getting the edition extracted was easy, but I am struggling to get the version into its own column. Attached is sample workbook. Any help is most appreciated. I have spent more time on this, than I thought it would take.
Thank you,
Bookmarks