If anyone can help with this tough one, I'd be delighted!
Assume cell A1 contains a set of words. If cell B1 contained the following formula, the contents of cell A1 will be shown in B1, minus the last word.
However, the space or gap before the word that has been removed will be present in cell B1.
eg. If A1 = "how are you", then B1 will = "how are ".
I need this space to be removed too.
ie. B1 = "how are"
Hope that makes sense!