software

I was wondering if there was a formula I could use in excel to split data out
from a single cell into multiple cells

ie Sydney NSW 2000 (Currently All in one cell)
Would like to know how to split quot;Sydneyquot; into it's own cell,quot;NSWquot; into its
own cell and respectively quot;2000quot; into its own cell

Thanksmaybe...

Select your range (one column at a time)
data|text to columns
delimited (by space)But that'll depend on what's really in those cells--and how you want them split.

davids wrote:
gt;
gt; I was wondering if there was a formula I could use in excel to split data out
gt; from a single cell into multiple cells
gt;
gt; ie Sydney NSW 2000 (Currently All in one cell)
gt; Would like to know how to split quot;Sydneyquot; into it's own cell,quot;NSWquot; into its
gt; own cell and respectively quot;2000quot; into its own cell
gt;
gt; Thanks

--

Dave Peterson