I have a very large spreadsheet with one column that start with similar text but pretty much every line is slightly different. Below is a rough idea on what I mean:

ID Software
1 Adobe Acrobat 1
2 Adobe Acrobat 2
3 Adobe Acrobat 3
4 Adobe Flash 1
5 Adobe Flash 2
6 Adobe Flash 3
7 Google Chrome 1
8 Google Chrome 2
9 Google Chrome 3


I want to group these based on say the first two or three words in each row. So looking at the above example I would want a group for Adobe Acrobat, a group for Adobe Flash and a group for Google Chrome plus i;d like to use subtotal function also to get a count of how many in each group.

My issue is I don't know how to get it to group based on part of the text e.g. the first two word.

Any help?

Thanks.