Splitting data out of a single cell

D

davids

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
 
D

Dave Peterson

maybe...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split cell help! 4
Split single cell into multiple cells 2
Merging from an Excel file with graphics 1
Cumulative formula for word table 0
Word macro that can call cells out of Excel for a find and replace 0
Converting excel to PDF, single page converts to multiple HELP! 1
Possible to Combine reports to's to a single box? 0
Insert Index into a Table 1

Top