Thread: break at space
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Learner[_4_] Learner[_4_] is offline
external usenet poster
 
Posts: 6
Default break at space

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