Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting CSV file in Excel
I'm trying to sort a CSV file in Excel. It has three colums with multiple
names in each cell (some are names, and some are run-on sentences for all three colums, they only separated by a space). I need to sort them alphabetically. Once I sort alphabetically I need a total amount for each name. I have tried various ways to do this. Does anyone have any suggestions for me? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting CSV file in Excel
do you want to separate the words first?? if so, got to data=text to columns= select delimited then next select comma then select finish, the words will seperate. besure not to have any info to the right of the coplumn because it will write over what you have if you let it, once you have the infor seperated you will have no prblem sorting it -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=517921 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting CSV file in Excel
Try DataSubtotals
HTH -- AP "Denise" <u19239@uwe a écrit dans le message de news:5c9d42452e299@uwe... I'm trying to sort a CSV file in Excel. It has three colums with multiple names in each cell (some are names, and some are run-on sentences for all three colums, they only separated by a space). I need to sort them alphabetically. Once I sort alphabetically I need a total amount for each name. I have tried various ways to do this. Does anyone have any suggestions for me? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting CSV file in Excel
Thanks Dave, I was afraid that was my only option. I've done a lot of
manipulating and it appears to be working fine. Thanks for responding. davesexcel wrote: do you want to separate the words first?? if so, got to data=text to columns= select delimited then next select comma then select finish, the words will seperate. besure not to have any info to the right of the coplumn because it will write over what you have if you let it, once you have the infor seperated you will have no prblem sorting it -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Insert & link a graphic file in Excel 2003 -- updatable pictures! | Excel Discussion (Misc queries) | |||
How do I unlock FILE access? | Excel Discussion (Misc queries) | |||
Reflecting info between an excel file and a word one or two excel file. | Links and Linking in Excel | |||
Very slow in opening Excel 97 file in Excel 2003 | Setting up and Configuration of Excel |