| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split cell help!
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| How do I keep the zeros in front of numbers when i split a cell | Excel Worksheet Functions | |||
| how to split the unmerge cell in Excel? | Excel Discussion (Misc queries) | |||
| Split Long Text Cell into Two Shorter Cells Without Splitting Word | Excel Discussion (Misc queries) | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
Threaded Mode
