Populate list of categories

[RIZVI]

I am running a small restaurant and have various categories of items. Under each category I have wide variety of items. For example, Pizza is one category, burger is another and so on and so forth. Under Pizza there will be various varities of items, like Pizza - x, Pizza - y and so on and so forth. In the day sales list, when an item is punched it comes with the category, space, hyphen, space and the name of the item. Like Pizza - Cheeze Double Crust Pizza 8"

I want to populate the list of only category from this sales list.

Currently I m using this formula: {=IFERROR(INDEX(DaySales,SMALL(IF(FREQUENCY(IF(DaySales<>"",IF(DailySalesQty<>0,MATCH(DaySales&"|"&DaySales,DaySales&"|"&DaySales,0))),IVecDailySales),IVecDailySales),ROWS(AN$3:AN3))),"")}

To get them sorted in alphabetic manner I then use this formula: {=INDEX($AN$3:$AN$348, MATCH(LARGE(COUNTIF($AN$3:$AN$348, ">="&$AN$3:$AN$348), ROWS(AO$3:$AO3)), COUNTIF($AN$3:$AN$348, ">="&$AN$3:$AN$348), 0))}

Is there a way to get only category by turncating from hyphen onwards. That is get only Pizza, Burger etc but not what is after that.


Looking forward for solution.

RGDS,

Rizvi.M.H.