Hello davids,

Check out this tutorial:

http://www.cpearson.com/excel/FirstLast.htm

Judith
--
Hope this helps


"davids" wrote:

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 "Sydney" into it's own cell,"NSW" into its
own cell and respectively "2000" into its own cell

Thanks