Prev: Leaving a formula cell blank when data has not yet been added.
Next: Saving as Binary
From: Going Crazy with excel Going Crazy with on 20 May 2010 21:15
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.

From: Brad on 20 May 2010 21:28
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.
>
 | 
Pages: 1
Prev: Leaving a formula cell blank when data has not yet been added.
Next: Saving as Binary