I have a large table which lists all of the apps currently deployed via iTunes to our school iPads.
ABA Flash Cards & Games- Emotions 4.2
ABC Circus 2.0
Add Strategy Lite 1.2
Adobe Reader 11.6.4
Amazing Time 1.0
At The Dump 1.0
Autism and PDD ConceptsLite 1.4
Autism Apps 2.6
Autism iHelp 1.0.1
Autism iHelp 1.3.0
I would like to split the App name eg: Bubbles from the version eg: 5.2, preferably into columns B and C respectively.
Or, just move the version info to column B leaving the name in Column A
I can't use the normal Left or Right functions as there isn't a consistent number of digits in the version data.
Any suggestions please?