Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Finding matching text in Excel columns

Status
Not open for further replies.
Jul 1, 2001
9
GB
I have 2 columns in Excel. Column A is a list of companies in a not so clean format:
FordMCo
MaybeIBM maybe not
4m of NH
Smiths
etc

Column B is a list of companies nicely clean and neat:
Ford
IBM
XYZ
4M
etc

Is there some code I can run to identify which companies in column A might match something in Column B? I don't want to do any replacing or changing - just need to end up knowing which ones might need some cleanup.

Grateful for any help at all!

Joann
 
In the VBA help have a look at the Like operator.
eg, "MaybeIBM maybe not" Like "*IBM*" is true.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 




Hi,

You could use the AutoFilter CONTAINS criteria operator.



Skip,

[glasses] [red][/red]
[tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top