Group together cells with common words

[Analystbycuriosity]

I have a long list of following cells.
e.g. cell A111: 9.03% XYZ investments Ltd. MD(23/06/2019)
A451: 7.52% ABC industries ltd.MD (12/02/2020)
A600: 8.56% XYZ investments Ltd. MD(45/05/2030)
A750: 7.52% ABC industries ltd.MD (12/02/2025)
and so on

Cells include different company names, percentage, and dates.
Like many other companies, XYZ investments is repeated in many cells but they are segregated.
I have searched using filters but it is very time-consuming and tedious task as there are 1000 such cells with 100 company names.
Normal sorting function arranges based on initial numbers hence of no use.
I want to group cells with similar companies automatically one after the other or in different columns using some formula and function.

Please, Help!

 

[Peter_SSs]

Welcome to the MrExcel board!

Would using a formula like this in another column and using that column to sort be any use for you?

Book1
	A	B
1
2	9.03% XYZ investments Ltd. MD(23/06/2019)	XYZ investments Ltd.
3	7.52% ABC industries ltd.MD (12/02/2020)	ABC industries ltd.
4	8.56% XYZ investments Ltd. MD(45/05/2030)	XYZ investments Ltd.
5	7.52% ABC industries ltd.MD (12/02/2025)	ABC industries ltd.
Group Companies

Cell Formulas
Range	Formula
B2	=TRIM(REPLACE(LEFT(A2,FIND("MD",A2)-1),1,FIND(" ",A2),""))

 

[Analystbycuriosity]

My desired Output.

A1: 9.03% XYZ investments Ltd. MD(23/06/2019)
A2: 8.56% XYZ investments Ltd. MD(45/05/2030)
A3: 7.52% ABC industries ltd.MD (12/02/2020)
A4: 7.52% ABC industries ltd.MD (12/02/2025)
......

 

[Peter_SSs]

My desired Output.

A1: 9.03% XYZ investments Ltd. MD(23/06/2019)
A2: 8.56% XYZ investments Ltd. MD(45/05/2030)
A3: 7.52% ABC industries ltd.MD (12/02/2020)
A4: 7.52% ABC industries ltd.MD (12/02/2025)
......

Yes, so as I suggested, if in my small sample I now select A2:B5 and sort on column B, doesn't that achieve the goal of grouping companies together?

Book1
	A	B
1
2	7.52% ABC industries ltd.MD (12/02/2020)	ABC industries ltd.
3	7.52% ABC industries ltd.MD (12/02/2025)	ABC industries ltd.
4	9.03% XYZ investments Ltd. MD(23/06/2019)	XYZ investments Ltd.
5	8.56% XYZ investments Ltd. MD(45/05/2030)	XYZ investments Ltd.
Group Companies

If it is a one-off task then column B formulas could then be deleted.

 

[Analystbycuriosity]

Thanks Peter. Got your logic.

 

[Peter_SSs]

Thanks Peter. Got your logic.

You are welcome. Thanks for letting us know.