Extract the last word/ number from a cell

Please sign up for the course before starting the lesson.

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.

Back to: Data cleanup in Excel > Split columns in Excel