Finding out the cells having similar words and arranging them in a column

[Dheeru3193]

I have a excel sheet which contains a column with around 500 rows. I want to arrange all the cells which are having any word in common. The cells are having 2-3 words.
How can i do this.

Format is like this....
Column 1

ABEL Brussels

ALHR France

ALPL France

ALSR France

ALSS Geneva

ALTP France

ALTS France

APOL Hyderabad

CEDG Mumbai

CMCA Louisiana

CMC Corporate Delhi

CMC Corporate Mumbai

CMCE Louisiana

CMC ER

CMC Gachibowli

CMC Global

CMC INTL

CMC MMC

CMC NR

CMC SR I

CMC SR II

CMC SR III

CMC WR I

CMC WR II

DILI2 Liverpool

DILI2 Liverpool(RM Office)

DILI Peterborough

DILI Peterborough(RM Office)

MGDC Guadalajara

MHOL Mumbai

<colgroup><col></colgroup><tbody>
</tbody>

Plz help

 

[oldbrewer]

ABEL Brussels	6	ABEL	Brussels
ALHR France	6	ALHR	France
ALPL France	6	ALPL	France
ALSR France	6	ALSR	France
ALSS Geneva	6	ALSS	Geneva
ALTP France	6	ALTP	France
ALTS France	6	ALTS	France
APOLLLL Hyderabad	9	APOLLLL	Hyderabad
CEDG Mumbai	6	CEDG	Mumbai
CMCA Louisiana	6	CMCA	Louisiana
by searching for the blank character you can use that number to break col A into 2 parts
then do a copy paste special values on cols C and D
then sort by col C and col D ascending

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>