software

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?


do you want to separate the words first??
if so,
got to data=gt;text to columns=gt; 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: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=517921Try Datagt;Subtotals

HTH
--
AP

quot;Denisequot; lt;u19239@uwegt; a écrit dans le message de news:5c9d42452e299@uwe...
gt; I'm trying to sort a CSV file in Excel. It has three colums with multiple
gt; names in each cell (some are names, and some are run-on sentences for all
gt; three colums, they only separated by a space). I need to sort them
gt; alphabetically. Once I sort alphabetically I need a total amount for each
gt; name. I have tried various ways to do this. Does anyone have any
gt; suggestions for me?
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:
gt;do you want to separate the words first??
gt;if so,
gt;got to data=gt;text to columns=gt; select delimited then next select comma
gt;then select finish,
gt;the words will seperate. besure not to have any info to the right of
gt;the coplumn because it will write over what you have if you let it,
gt;once you have the infor seperated you will have no prblem sorting it
gt;

--
Message posted via www.officekb.com