I forgot to mention that I have all the words in one cell.
Thanks
____
"Learner" wrote in message
...
Hello, I have thousands of nouns separated by a space (abandonments
abbreviating abbreviation abbreviators ...) and I would like to put a
formula so that at each space the remaining is copied to the next cell
(killing the needless space).

Can it be done, can you hint me to how to do this?

thank you