| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting multiple cell contents from 1st column into 4 columns
n my first column I have 4 cells (1-4) (5-8) etc. with general content.
The content from each of these 4 cells needs to be placed in a separate column to make a list that I can sort etc. Example: COLUMN A 1 01-04-425-001 2 Heatherridge Road #301 3 Harry Smith 4 H25 Condo Fairfax Place 5 01-05-356-041 6 McGrath Street # 56 7 Mary Jones 8 B45 Condo Lemon Circle . . . . . . and so on and so on every 4 cells. I have hundreds of 4 cell descriptions. I just can't do this one by one. Can anyone help, PLEASE, PLEASE. I am really a novice at Excel though I use it for everything everyday. There must be some kind of a formula or something. Thank you so much in advance. I can't spend the next 6 months doing this one by one or retyping each one. I have many other things to do in my job. By the way I am on a MAC 10.4.11 using Excel 2004 if that makes a difference. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Splitting Text from single cell in column across multiple Columns | Excel Worksheet Functions | |||
| Splitting contents of a cell from one column into 2 | Excel Worksheet Functions | |||
| print excel spreadsheet splitting cell contents on multiple pages | Excel Discussion (Misc queries) | |||
| Splitting one column into multiple columns | Excel Worksheet Functions | |||
| Splitting multiple cell contents containing values at end | Excel Worksheet Functions | |||
Threaded Mode
