Hello excelforum,
I'm hoping you can help me. I have a spreadsheet with two sheets. On one sheet I have a list of over 300 companies in the first column. The subsequent columns on that sheet have address, email, phone, etc. On the second sheet I have only one column with 60 of those companies. I would like to filter and delete all but those 60 companies from the first sheet. The problem is the company names on the second sheet are not formatted exactly the same. They are almost identical, but the names have extra spaces. A lot of the companies have similar names, which might complicate it. I thought about using find and replace to remove the spaces, but not all of them have the extra spaces. Whats the best way to do this? I am attaching a sample file. Thank you!
Bookmarks