How do I split a clustered alphanumeric column at the first instance of a number?
Preferrably simpler than this.
To achieve what you want simpler than suggested by MS, do the following:
These options (wildcards) mean the following:
Now save the resulting file as TEXT (not Word Document!), change extension to CSV and simply open it in Excel. If your default CSV separator is comma - you'll have strings with comma separated into 2 cells. If you have different default separator - replace comma in the above "Replace with:" expression by this character.
Read more about wildcards: Finding and replacing characters using wildcards.
Have a look at this article from microsoft: http://office.microsoft.com/en-us/excel-help/extracting-numbers-from-alphanumeric-strings-HA001154901.aspx