Convert multiple versions of cell contents to a single version

[tmelnink]

This is my first post so I hope this is the correct place.

I would like to automate the conversion of multiple versions of company names contained in cells to a single company name. i.e. XYZ Inc., XYZ Co., XYZ to all cells XYZ. My data file contains numerous versions of company names. I want them to all be the same company name so sorting data is easier. I now do this manually and it is getting tedious and time consuming. Can I build a table with the different versions that then chamges the cells to a single version that I choose?

Thanks!

[Bhuvi]

Hi,
Welcome to the forum
are company names always continuos characters with the co or inc follows after space bar ? eg. xxxxx co.

you can use the below formula in this case if names are in col A and starting from cell A1 (it removes all characters after space)

Please Login or Register  to view this content.

OR
you can do text to columns with space