| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Adding Colum to a Row od info...
Do you want to split Row 1's information into columns?
Eg: Col 1 Col 2 Col 3 Col 4 America 06/03/2007 America Here & Now If that is the case the I would assume that all of your information is in column A only? Highlight the range from start cell (Row 1) to last cell in column A only and select DataText to ColumnsNext select Other and put your - in the box, Next, you may need to scroll down here to get to a line that has the most information separated by the - and then click Finish. "Jeff" wrote: I have a music database when opened in Excel in has all info in rows and I would like to add a few columns. Want to Add Col 1 Col 2 Col 3 Example: Row 1 America - 06/03/2007 - America - Here & Now [Disc 1] Is there a way to do this as the database is quite large. I have Office 2007. TIA Jeff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding Info to Chart | Charts and Charting in Excel | |||
| Adding Up cells in one colum IF cell in another column is yes | Excel Worksheet Functions | |||
| Keeping a sum colum correct after inserting a colum of data in fro | Excel Discussion (Misc queries) | |||
| Check data on colum A and find match on colum b | Excel Discussion (Misc queries) | |||
| Adding info onto a "permanent" form | Excel Worksheet Functions | |||
Threaded Mode
