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...
Version 16.83
student1231 OK, you're on a Mac and a modern version.
I quickly cooked up a formula based solution that should work for you as well. It's not great and probably needs improvement. That's why I prefer PQ for this. So much easier and neater, despite the fact that you need to do a refresh when the underlying data changes.
