| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving Related Fields
I have a very large worksheet that is seperated between item codes and the
categories related to those items. However, the way the worksheet comes pre-formated: 3160WW AUD3000 3160WW AUD4000 3160WW AUD6000 3170WX SAM1300 I want to move all the related categories into seperate fields: 3160WW AUD3000 AUD4000 AUD 6000 3170WX SAM1300 How do I do this in excel? I know access a little if I need to do it in that. Also I would want to add the additional text "PC" to the item codes: PC3160WW Thanks, please send me an e-mail if you have a fix to this delima at pcelite2 @ (no spam) yahoo.com THANKS. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving Pivot Chart Fields on a chart sheet | Charts and Charting in Excel | |||
| Pivot table # of fields | Excel Discussion (Misc queries) | |||
| Need pie chart with number of fields instead of info in fields | Charts and Charting in Excel | |||
| Number of dropdown fields in Excel is limited. I need more. How? | Excel Discussion (Misc queries) | |||
| Sorting Spreadsheet with Merged Fields | Excel Discussion (Misc queries) | |||
Threaded Mode
