A more difficult split of a cell into multiple columns is where you only want a certain part e.g. the last word or number, but there is no consistent indicator of where the last part is. There are various numbers of spaces, dashes etc and in each case it could be different e.g. _My Documents \ Other \ Global Procurement versus _My Documents \ Other .
This is where we need to start massaging the data to get it to give us what we want.
Extract the last word/ number from a cell
You don’t have access to this lesson
Please purchase this course, or sign in if you’re already enrolled, to access the course content.