Extract the last word/ number from a cell
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.