Forum Discussion
Help Needed
I am looking for help with extracting certain parts of a cell. Some example cells appear as the following: AUS177-4M Canada551-3W ENG342-10Mo The first set of text is a location. The first s...
student1231 I prefer to perform such tasks with Power Query. It's no more than two steps of splitting. The first split is by the "-". The second split is where the text in the now 2nd column changes from a digit (i.e. a number) to a non-digit (i.e. a letter).
See attached.
student1231 I guess so. What Excel version are you using?
- Version 16.83
