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

Thanks
Hello davids,

Check out this tutorial:

www.cpearson.com/excel/FirstLast.htm

Judith
--
Hope this helpsquot;davidsquot; wrote:

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
gt;
gt;

I don't know of a formula but try selecting the cell containing the data,
then from top toolbar- data -text to columns.

Select delimited, then space as your delimiter. Should have the desired
effect if you are looking for a one off fix!

davids wrote:
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

this works but it is limited say for instance my suburb is called quot;lane covequot;
i get quot;lanequot; in its own column and quot;covequot; in its own column is there a way to
keep quot;lane covequot; in one cell then quot;NSWquot; in its own cell and then quot;2022quot; in
its own cell?

quot;pau1aquot; wrote:

gt; I don't know of a formula but try selecting the cell containing the data,
gt; then from top toolbar- data -text to columns.
gt;
gt; Select delimited, then space as your delimiter. Should have the desired
gt; effect if you are looking for a one off fix!
gt;
gt; davids wrote:
gt; gt;I was wondering if there was a formula I could use in excel to split data out
gt; gt;from a single cell into multiple cells
gt; gt;
gt; gt;ie Sydney NSW 2000 (Currently All in one cell)
gt; gt;Would like to know how to split quot;Sydneyquot; into it's own cell,quot;NSWquot; into its
gt; gt;own cell and respectively quot;2000quot; into its own cell
gt; gt;
gt; gt;Thanks
gt;

On Wed, 22 Mar 2006 15:50:35 -0800, davids gt;
wrote:

gt;this works but it is limited say for instance my suburb is called quot;lane covequot;
gt;i get quot;lanequot; in its own column and quot;covequot; in its own column is there a way to
gt;keep quot;lane covequot; in one cell then quot;NSWquot; in its own cell and then quot;2022quot; in
gt;its own cell?

I think you need to present us with the possible variations in order to obtain
a coherent answer.

Will NSW always be NSW? If not, how do we differentiate it from the rest of
the string.

For example: is it always a three letter string of capital letters that
precedes a four digit number that ends the string? Or are there more
variations than that?--ron