Check out text to columns on the ribbon or menu tabs
--
Wag more, bark less


"Going Crazy with excel" wrote:

Trying to separate characters, and numbers from one cell into separate cells.
I thought I knew the formual, but can't find it anywhere.
Example in cell:
1 better-samual
disired result in two adjacent cells:
better
samual
can this be done with a single formula?
Thanks for your help.