| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Column Break Up
Hi
Is there any way I can break up the following in three different columns? Date, Merchant and Amount? At presnt, all info is in one column. Thanks 01/01/08 ALBERTSONS #6555 UPLAND, CA $3.23 01/01/08 VONS FUEL 10026813 UPLAND, CA $35.50 01/01/08 WAL-MART #1992 UPLAND, CA $17.80 01/02/08 GRAZIANOS ITALIAN RESTAUR UPLAND, CA $12.00 01/02/08 GRAZIANOS ITALIAN RESTAUR UPLAND, CA $7.50 01/02/08 SHELL OIL 57442712808 UPLAND, CA $31.50 01/03/08 MIMIS CAFE 00000125 UPLAND, CA $14.73 01/27/08 UPLAND FARMERS MARKET UPLAND, CA $19.09 01/27/08 VONS Store00026815 UPLAND, CA $24.70 01/28/08 ALBERTSONS #6555 UPLAND, CA $20.50 01/28/08 VONS FUEL 10026813 UPLAND, CA $39.50 01/29/08 NEW BOMBAY STORES UPLAND, CA $27.35 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Repeat Values in Column A, Break and Sum | Excel Discussion (Misc queries) | |||
| Page Break Column Headers | Excel Worksheet Functions | |||
| Break up column | Excel Discussion (Misc queries) | |||
| EXCEL 2000 SINGLE COLUMN OF NUMBERS BREAK INTO MANY COLUMNS | Excel Worksheet Functions | |||
| I have ad address in one column. I need to break apart the data | New Users to Excel | |||
Threaded Mode
