Pulling out last words from the end of a text string - dynamically

[davidx]

Hi,

I was wondering if anyone has a formula which makes it possible to pull out the last x number of words, separated by a space.

It would be very cool if the number of words from the right to be pulled could easily be decided by an input. e.g. typing 1 into a cell (or as a column heading) would mean we would pull out the last word (1st word from the right).

I think using the search function would be the best way to do it, but I can't seem to get this to work left to right instead of right to left.

Thanks folks for anyone who tries to crack this.

File attached

[tigeravatar]

davidx,

Using your provided workbook, on sheet 'After' cell L3 and copied over and down to cell O14:

Please Login or Register  to view this content.

[EDIT]:
And if you want to remove the commas:

Please Login or Register  to view this content.

[davidx]

thank you so much, that is really sensational stuff!!!!!!!!!!!!!!