Cleaning up company names?

J

jpbertram

New Member
Joined
Jul 18, 2013
Messages
4
I'm trying to clean up company names in a large spreadsheet. For example, get rid of the "Inc.", "Corp.", etc.

Is there an formula to automatically normalize all entries in a single column?

Thanks!

<style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl63 { color: black; }</style> [TABLE="class: grid, width: 65"]
<colgroup><col style="width:65pt" width="65"> </colgroup><tbody>[TR]
[TD="width: 65"]Old Republic Title Company
[/TD]
[/TR]
[TR]
[TD]American Reprographics Company, L.L.C.[/TD]
[/TR]
[TR]
[TD]Symphony Teleca Corporation[/TD]
[/TR]
[TR]
[TD]American Baptist Homes of The West[/TD]
[/TR]
[TR]
[TD]Svb Financial Group[/TD]
[/TR]
[TR]
[TD]Symphony Teleca Corporation[/TD]
[/TR]
[TR]
[TD]Wilson Sonsini Goodrich & Rosati, Professional Corporation[/TD]
[/TR]
[TR]
[TD]Osisoft, LLC[/TD]
[/TR]
[TR]
[TD]Risk Management Solutions, Inc.[/TD]
[/TR]
[TR]
[TD]Epicor Software Corporation[/TD]
[/TR]
[TR]
[TD]Marin Health Care District[/TD]
[/TR]
[TR]
[TD]Prologis, Inc.[/TD]
[/TR]
[TR]
[TD]Fenwick & West LLP[/TD]
[/TR]
[TR]
[TD]Symphony Technology Group, L.L.C.[/TD]
[/TR]
[TR]
[TD]Universal Building Services and Supply Co.[/TD]
[/TR]
[TR]
[TD]Woodruff-Sawyer & Co.[/TD]
[/TR]
[TR]
[TD]American Baptist Homes of The West[/TD]
[/TR]
[TR]
[TD]Tectura Corporation[/TD]
[/TR]
[TR]
[TD]Hcl America Inc.[/TD]
[/TR]
[TR]
[TD]Eah Inc.[/TD]
[/TR]
[TR]
[TD]Healthright 360[/TD]
[/TR]
[TR]
[TD]La Clinica De La Raza, Inc.[/TD]
[/TR]
[TR]
[TD]Abbott Vascular Inc.[/TD]
[/TR]
[TR]
[TD]Trinet Group, Inc.[/TD]
[/TR]
[TR]
[TD]Marklogic Corporation[/TD]
[/TR]
[TR]
[TD]Wested[/TD]
[/TR]
[TR]
[TD]Workday, Inc.[/TD]
[/TR]
[TR]
[TD]Genesys Telecommunications Laboratories, Inc.[/TD]
[/TR]
[TR]
[TD]Extend Health, Inc.[/TD]
[/TR]
[TR]
[TD]Linkedin Corporation[/TD]
[/TR]
[TR]
[TD]Fair Isaac Corporation[/TD]
[/TR]
[TR]
[TD]Exigen (usa), Inc.[/TD]
[/TR]
[TR]
[TD]Tiburon, Inc.[/TD]
[/TR]
[TR]
[TD]Cisco Webex LLC[/TD]
[/TR]
[TR]
[TD]Charles Schwab & Co., Inc[/TD]
[/TR]
[TR]
[TD]Sonicwall, Inc.[/TD]
[/TR]
[TR]
[TD]Epicor Software Corporation[/TD]
[/TR]
[TR]
[TD]Bingham McCutchen LLP[/TD]
[/TR]
[TR]
[TD]Successfactors, Inc.[/TD]
[/TR]
[TR]
[TD]Orrick, Herrington, Sutcliffe LLP[/TD]
[/TR]
[TR]
[TD]Linkedin Corporation[/TD]
[/TR]
[TR]
[TD]Genesys Telecommunications Laboratories, Inc.[/TD]
[/TR]
[TR]
[TD]California Physicians' Service[/TD]
[/TR]
[TR]
[TD]Genesys Telecommunications Laboratories, Inc.[/TD]
[/TR]
[TR]
[TD]Sequoia Equities, Incorporated[/TD]
[/TR]
[TR]
[TD]Cooley LLP[/TD]
[/TR]
[TR]
[TD]El Camino Hospital[/TD]
[/TR]
[TR]
[TD]Risk Management Solutions, Inc.[/TD]
[/TR]
[TR]
[TD]Cypress Security, LLC[/TD]
[/TR]
[TR]
[TD]Essex Property Trust, Inc.[/TD]
[/TR]
[TR]
[TD]Good Fellow Top Grade Construction, LLC[/TD]
[/TR]
[TR]
[TD]Public Health Institute[/TD]
[/TR]
[TR]
[TD]The PMI Group Inc[/TD]
[/TR]
[TR]
[TD]RCM Capital Management LLC[/TD]
[/TR]
[TR]
[TD]Hanson Bridgett LLP[/TD]
[/TR]
[TR]
[TD]Advantis Global, Inc.[/TD]
[/TR]
[TR]
[TD]Braden Partners, L.P., A California Limited Partnership[/TD]
[/TR]
[TR]
[TD]Taos Mountain, Inc.[/TD]
[/TR]
[TR]
[TD]Systems Integration Solutions Inc[/TD]
[/TR]
[TR]
[TD]Symphony Technology Group, L.L.C.[/TD]
[/TR]
[TR]
[TD]Quinstreet, Inc.[/TD]
[/TR]
[TR]
[TD]Cmg Mortgage, Inc.[/TD]
[/TR]
[TR]
[TD]Risk Management Solutions, Inc.[/TD]
[/TR]
[TR]
[TD]Svb Financial Group[/TD]
[/TR]
[TR]
[TD]Paypal, Inc.[/TD]
[/TR]
[TR]
[TD]Astreya Partners, Inc.[/TD]
[/TR]
[TR]
[TD]Wageworks, Inc.[/TD]
[/TR]
[TR]
[TD]Netsuite, Inc.[/TD]
[/TR]
[TR]
[TD]E2open, Inc.[/TD]
[/TR]
[TR]
[TD]Responsys, Inc.[/TD]
[/TR]
[TR]
[TD]Bonhams & Butterfields Auctioneers Corporation[/TD]
[/TR]
[TR]
[TD]American Baptist Homes of The West[/TD]
[/TR]
[TR]
[TD]Hanna, Brophy, Mac Lean, Mc Aleer & Jensen, LLP[/TD]
[/TR]
[TR]
[TD]Triage Consulting Group[/TD]
[/TR]
[TR]
[TD]McGrath Rentcorp[/TD]
[/TR]
[TR]
[TD]Oil Changer, Inc.[/TD]
[/TR]
[TR]
[TD]Douglas Parking Company LLC[/TD]
[/TR]
[TR]
[TD]Telecare Corporation[/TD]
[/TR]
[TR]
[TD]Sonicwall, Inc.[/TD]
[/TR]
[TR]
[TD]Saba Software, Inc.[/TD]
[/TR]
[TR]
[TD]Risk Management Solutions, Inc.[/TD]
[/TR]
[TR]
[TD]Prologis, Inc.[/TD]
[/TR]
[TR]
[TD]Freeborders, Inc.[/TD]
[/TR]
[TR]
[TD]Cooley LLP[/TD]
[/TR]
[TR]
[TD]E4e, Inc.[/TD]
[/TR]
[TR]
[TD]Linkedin Corporation[/TD]
[/TR]
[TR]
[TD]Visa International Service Association[/TD]
[/TR]
[TR]
[TD]Actian Corporation[/TD]
[/TR]
[TR]
[TD]It Convergence[/TD]
[/TR]
[TR]
[TD]Fair Isaac Corporation[/TD]
[/TR]
[TR]
[TD]Symphony Teleca Corporation[/TD]
[/TR]
[TR]
[TD]Linkedin Corporation[/TD]
[/TR]
[TR]
[TD]Check Point Software Technologies, Inc.[/TD]
[/TR]
[TR]
[TD]Check Point Software Technologies, Inc.[/TD]
[/TR]
[TR]
[TD]Visa International Service Association[/TD]
[/TR]
[TR]
[TD]Trulia, Inc.[/TD]
[/TR]
[TR]
[TD]M. Arthur Gensler Jr. & Associates, Inc.[/TD]
[/TR]
[TR]
[TD]Selectquote Insurance Services[/TD]
[/TR]
[TR]
[TD]Kinetic Systems, Inc[/TD]
[/TR]
[TR]
[TD]Hcl America Inc.[/TD]
[/TR]
[TR]
[TD]Exponent, Inc.[/TD]
[/TR]
[TR]
[TD]American Cancer Society California Division, Inc[/TD]
[/TR]
[TR]
[TD]Blood Centers of The Pacific[/TD]
[/TR]
[TR]
[TD]Risk Management Solutions, Inc.[/TD]
[/TR]
[TR]
[TD]Essex Property Trust, Inc.[/TD]
[/TR]
[TR]
[TD]Osisoft, LLC[/TD]
[/TR]
[TR]
[TD]Vm Services, Inc.[/TD]
[/TR]
[TR]
[TD]American Baptist Homes of The West[/TD]
[/TR]
[TR]
[TD]First American Title Guaranty Holding Company[/TD]
[/TR]
[TR]
[TD]Blood Centers of The Pacific[/TD]
[/TR]
[TR]
[TD]American Cancer Society California Division, Inc[/TD]
[/TR]
[TR]
[TD]La Clinica De La Raza, Inc.[/TD]
[/TR]
[TR]
[TD]Taleo Corporation[/TD]
[/TR]
[TR]
[TD]Orrick, Herrington, Sutcliffe LLP[/TD]
[/TR]
[TR]
[TD]Qualys, Inc.[/TD]
[/TR]
[TR]
[TD]Actuate Corporation[/TD]
[/TR]
[TR]
[TD]CBS Interactive Inc.[/TD]
[/TR]
[TR]
[TD]Armanino McKenna LLP[/TD]
[/TR]
[TR]
[TD]Splunk Inc.[/TD]
[/TR]
[TR]
[TD]It Convergence[/TD]
[/TR]
[TR]
[TD]Trinet Group, Inc.[/TD]
[/TR]
[TR]
[TD]Tibco Software Inc.[/TD]
[/TR]
[TR]
[TD]Trinet Group, Inc.[/TD]
[/TR]
[TR]
[TD]Delta Dental of California[/TD]
[/TR]
[TR]
[TD]Visa International Service Association[/TD]
[/TR]
[TR]
[TD]Informatica Corporation[/TD]
[/TR]
[TR]
[TD]Paypal, Inc.[/TD]
[/TR]
[TR]
[TD]Linkedin Corporation[/TD]
[/TR]
[TR]
[TD]Trianz, Inc.[/TD]
[/TR]
[TR]
[TD]Trulia, Inc.[/TD]
[/TR]
[TR]
[TD]Delta Dental of California[/TD]
[/TR]
[TR]
[TD]Visa International Service Association[/TD]
[/TR]
[TR]
[TD]Fair Isaac Corporation[/TD]
[/TR]
[TR]
[TD]Trinet Group, Inc.[/TD]
[/TR]
[TR]
[TD]M. Arthur Gensler Jr. & Associates, Inc.[/TD]
[/TR]
[TR]
[TD]Burr Pilger Mayer, Inc.[/TD]
[/TR]
[TR]
[TD]Lucasfilm Ltd., Llc.[/TD]
[/TR]
[TR]
[TD]Harris & Associates, Inc.[/TD]
[/TR]
[TR]
[TD]Proofpoint, Inc.[/TD]
[/TR]
[TR]
[TD]Orrick, Herrington, Sutcliffe LLP[/TD]
[/TR]
[TR]
[TD]Responsys, Inc.[/TD]
[/TR]
[TR]
[TD]IAC Search & Media, Inc.[/TD]
[/TR]
[TR]
[TD]Essex Property Trust, Inc.[/TD]
[/TR]
[TR]
[TD]Wested[/TD]
[/TR]
[TR]
[TD]Epocrates, Inc.[/TD]
[/TR]
[TR]
[TD]Trinet Group, Inc.[/TD]
[/TR]
[TR]
[TD]Akqa, Inc.[/TD]
[/TR]
[TR]
[TD]Trianz, Inc.[/TD]
[/TR]
[TR]
[TD]Imperva, Inc.[/TD]
[/TR]
[TR]
[TD]Woodruff-Sawyer & Co.[/TD]
[/TR]
[TR]
[TD]Electric Power Research Institute, Inc.[/TD]
[/TR]
[TR]
[TD]Harris & Associates, Inc.[/TD]
[/TR]
[TR]
[TD]Infogain Corporation[/TD]
[/TR]
[TR]
[TD]Trinet Group, Inc.[/TD]
[/TR]
[TR]
[TD]Svb Financial Group[/TD]
[/TR]
[TR]
[TD]McGrath Rentcorp[/TD]
[/TR]
[TR]
[TD]Samsung Information Systems America, Inc.[/TD]
[/TR]
[TR]
[TD]Burr Pilger Mayer, Inc.[/TD]
[/TR]
[TR]
[TD]Epicor Software Corporation[/TD]
[/TR]
[TR]
[TD]Svb Financial Group[/TD]
[/TR]
[TR]
[TD]Lifelong Medical Care[/TD]
[/TR]
[TR]
[TD]Leisure Sports, Inc.[/TD]
[/TR]
[TR]
[TD]American Baptist Homes of The West[/TD]
[/TR]
[TR]
[TD]La Clinica De La Raza, Inc.[/TD]
[/TR]
[TR]
[TD]Taleo Corporation[/TD]
[/TR]
[TR]
[TD]Fair Isaac Corporation[/TD]
[/TR]
[TR]
[TD]American Baptist Homes of The West[/TD]
[/TR]
[TR]
[TD]The Marcus & Millichap Company[/TD]
[/TR]
[TR]
[TD]CBS Interactive Inc.[/TD]
[/TR]
[TR]
[TD]The Hospital Committee For The Livermore-Pleasanton Areas[/TD]
[/TR]
[TR]
[TD]Good Fellow Top Grade Construction, LLC[/TD]
[/TR]
[TR]
[TD]Responsys, Inc.[/TD]
[/TR]
[TR]
[TD]Arcsoft, Inc.[/TD]
[/TR]
[TR]
[TD]Blood Centers of The Pacific[/TD]
[/TR]
[TR]
[TD]Ehealthinsurance Services, Inc.[/TD]
[/TR]
[TR]
[TD]American Baptist Homes of The West[/TD]
[/TR]
[TR]
[TD]Anka Behavioral Health, Incorporated[/TD]
[/TR]
[TR]
[TD]Responsys, Inc.[/TD]
[/TR]
[TR]
[TD]Phoenix Technologies Ltd.[/TD]
[/TR]
[TR]
[TD]San Benito Health Care District[/TD]
[/TR]
[TR]
[TD]Saba Software, Inc.[/TD]
[/TR]
[TR]
[TD]Wilson Sonsini Goodrich & Rosati, Professional Corporation[/TD]
[/TR]
[TR]
[TD]Yodlee, Inc.[/TD]
[/TR]
[TR]
[TD]Cybernet Software Systems Inc[/TD]
[/TR]
[TR]
[TD]American Baptist Homes of The West[/TD]
[/TR]
[TR]
[TD]Mid-Peninsula Housing Management Corporation[/TD]
[/TR]
[TR]
[TD]Trinet Group, Inc.[/TD]
[/TR]
[TR]
[TD]Satellite Healthcare, Inc.[/TD]
[/TR]
[TR]
[TD]Embarcadero Technologies, Inc.[/TD]
[/TR]
[TR]
[TD]Shutterfly, Inc.[/TD]
[/TR]
[TR]
[TD]Taos Mountain, Inc.[/TD]
[/TR]
[TR]
[TD]Blood Centers of The Pacific[/TD]
[/TR]
[TR]
[TD]Exponent, Inc.[/TD]
[/TR]
[TR]
[TD]Hatch Mott Macdonald, LLC[/TD]
[/TR]
[TR]
[TD]Nagarro Inc.[/TD]
[/TR]
[TR]
[TD]El Camino Hospital[/TD]
[/TR]
[TR]
[TD]Epicor Software Corporation[/TD]
[/TR]
[TR]
[TD]Harris & Associates, Inc.[/TD]
[/TR]
[TR]
[TD]El Camino Hospital[/TD]
[/TR]
[TR]
[TD]American Baptist Homes of The West[/TD]
[/TR]
[TR]
[TD]Performant Financial Corporation[/TD]
[/TR]
[TR]
[TD]El Camino Hospital[/TD]
[/TR]
[TR]
[TD]Wested[/TD]
[/TR]
[TR]
[TD]Servicesource International, Inc.[/TD]
[/TR]
[TR]
[TD]Trinet Group, Inc.[/TD]
[/TR]
[TR]
[TD]Linkedin Corporation[/TD]
[/TR]
[TR]
[TD]Sybase, Inc.[/TD]
[/TR]
[TR]
[TD]Actuate Corporation[/TD]
[/TR]
[TR]
[TD]Linkedin Corporation[/TD]
[/TR]
[TR]
[TD]Iasco[/TD]
[/TR]
[TR]
[TD]Akqa, Inc.[/TD]
[/TR]
[TR]
[TD]Collateral Specialists Inc.[/TD]
[/TR]
[TR]
[TD]Ehealthinsurance Services, Inc.[/TD]
[/TR]
[TR]
[TD]Ehealthinsurance Services, Inc.[/TD]
[/TR]
[TR]
[TD]Sonicwall, Inc.[/TD]
[/TR]
[TR]
[TD]Business Wire, Inc.[/TD]
[/TR]
[TR]
[TD]Wested[/TD]
[/TR]
[TR]
[TD]Nexant, Inc.[/TD]
[/TR]
[TR]
[TD]Cisco Systems LLC[/TD]
[/TR]
[TR]
[TD]Paypal, Inc.[/TD]
[/TR]
[TR]
[TD]Trinet Group, Inc.[/TD]
[/TR]
[TR]
[TD]Visa International Service Association[/TD]
[/TR]
[TR]
[TD]Svb Financial Group[/TD]
[/TR]
[TR]
[TD]El Camino Hospital[/TD]
[/TR]
[TR]
[TD]Liveops, Inc.[/TD]
[/TR]
[TR]
[TD]Delta Dental of California[/TD]
[/TR]
[TR]
[TD]Epicor Software Corporation[/TD]
[/TR]
[TR]
[TD]Vm Services, Inc.[/TD]
[/TR]
[TR]
[TD]Epicor Software Corporation[/TD]
[/TR]
[TR]
[TD]Shorenstein Properties LLC[/TD]
[/TR]
[TR]
[TD]SRI International[/TD]
[/TR]
[TR]
[TD]Achievo Corporation[/TD]
[/TR]
[TR]
[TD]Trinet Group, Inc.[/TD]
[/TR]
[TR]
[TD]Risk Management Solutions, Inc.[/TD]
[/TR]
[TR]
[TD]Prologis, Inc.[/TD]
[/TR]
[TR]
[TD]Actuate Corporation[/TD]
[/TR]
[TR]
[TD]Bay Area Credit Service, LLC[/TD]
[/TR]
[TR]
[TD]Verisight, Inc.[/TD]
[/TR]
[TR]
[TD]Ehealthinsurance Services, Inc.[/TD]
[/TR]
[TR]
[TD]Trinet Group, Inc.[/TD]
[/TR]
[TR]
[TD]Provident Funding Associates, L.P.[/TD]
[/TR]
[TR]
[TD]Gordon & Rees LLP[/TD]
[/TR]
[TR]
[TD]Akqa, Inc.[/TD]
[/TR]
[TR]
[TD]Synarc Inc.[/TD]
[/TR]
[TR]
[TD]Wested[/TD]
[/TR]
[TR]
[TD]Wested[/TD]
[/TR]
[TR]
[TD]Wested[/TD]
[/TR]
[TR]
[TD]Proofpoint, Inc.[/TD]
[/TR]
[TR]
[TD]Freeborders, Inc.[/TD]
[/TR]
[TR]
[TD]Jive Software Inc.[/TD]
[/TR]
[TR]
[TD]California Physicians' Service[/TD]
[/TR]
[TR]
[TD]Farella Braun + Martel LLP[/TD]
[/TR]
[TR]
[TD]Ironplanet, Inc.[/TD]
[/TR]
[TR]
[TD]Satmetrix Systems, Inc.[/TD]
[/TR]
[TR]
[TD]Pier 39 Limited Partnership[/TD]
[/TR]
[TR]
[TD]Charles Schwab & Co., Inc[/TD]
[/TR]
[TR]
[TD]IAC Search & Media, Inc.[/TD]
[/TR]
[TR]
[TD]Svb Financial Group[/TD]
[/TR]
[TR]
[TD]Svb Financial Group[/TD]
[/TR]
[TR]
[TD]Kelleyamerit Fleet Services Inc.[/TD]
[/TR]
[TR]
[TD]Satellite Healthcare, Inc.[/TD]
[/TR]
[TR]
[TD]Visa International Service Association[/TD]
[/TR]
[TR]
[TD]SRI International[/TD]
[/TR]
[TR]
[TD]Essex Property Trust, Inc.[/TD]
[/TR]
[TR]
[TD]Risk Management Solutions, Inc.[/TD]
[/TR]
[TR]
[TD]El Camino Hospital[/TD]
[/TR]
[TR]
[TD]John Stewart Company[/TD]
[/TR]
[TR]
[TD]CBS Interactive Inc.[/TD]
[/TR]
[TR]
[TD]Netsuite, Inc.[/TD]
[/TR]
[TR]
[TD]California Physicians' Service[/TD]
[/TR]
[TR]
[TD]Enterprise Rent-A-Car Co of San Francisco, LLC[/TD]
[/TR]
[TR]
[TD]Coastal International, Inc.[/TD]
[/TR]
[TR]
[TD]Federal Reserve Bank of San Francisco[/TD]
[/TR]
[TR]
[TD]American Baptist Homes of The West[/TD]
[/TR]
[TR]
[TD]Anka Behavioral Health, Incorporated[/TD]
[/TR]
[TR]
[TD]N Model Inc[/TD]
[/TR]
[TR]
[TD]Exponent, Inc.[/TD]
[/TR]
[TR]
[TD]Farella Braun + Martel LLP[/TD]
[/TR]
[TR]
[TD]Trinet Group, Inc.[/TD]
[/TR]
[TR]
[TD]Genesys Telecommunications Laboratories, Inc.[/TD]
[/TR]
[TR]
[TD]Techlink Systems, Inc.[/TD]
[/TR]
[TR]
[TD]Trinet Group, Inc.[/TD]
[/TR]
[TR]
[TD]Telecare Corporation[/TD]
[/TR]
[TR]
[TD]Barracuda Networks, Inc[/TD]
[/TR]
[TR]
[TD]Burr Pilger Mayer, Inc.[/TD]
[/TR]
[TR]
[TD]Celera Corporation[/TD]
[/TR]
[TR]
[TD]Triage Consulting Group[/TD]
[/TR]
[TR]
[TD]Wested[/TD]
[/TR]
[TR]
[TD]Proofpoint, Inc.[/TD]
[/TR]
[TR]
[TD]Embarcadero Technologies, Inc.[/TD]
[/TR]
[TR]
[TD]American Baptist Homes of The West[/TD]
[/TR]
[TR]
[TD]Advent Software, Inc.[/TD]
[/TR]
[TR]
[TD]Satmetrix Systems, Inc.[/TD]
[/TR]
[TR]
[TD]CBS Interactive Inc.[/TD]
[/TR]
[TR]
[TD]Wageworks, Inc.[/TD]
[/TR]
[TR]
[TD]Trinet Group, Inc.[/TD]
[/TR]
[TR]
[TD]Trinet Group, Inc.[/TD]
[/TR]
[TR]
[TD]Federal Reserve Bank of San Francisco[/TD]
[/TR]
[TR]
[TD]Tibco Software Inc.[/TD]
[/TR]
[TR]
[TD]Abbott Vascular Inc.[/TD]
[/TR]
[TR]
[TD]Servicesource International, Inc.[/TD]
[/TR]
[TR]
[TD]Cloudera, Inc.[/TD]
[/TR]
[TR]
[TD]Fair Isaac Corporation[/TD]
[/TR]
[TR]
[TD]SRI International[/TD]
[/TR]
[TR]
[TD]Eah Inc.[/TD]
[/TR]
[TR]
[TD]Novogradac & Company LLP[/TD]
[/TR]
[TR]
[TD]Fireman's Fund Insurance Company[/TD]
[/TR]
[TR]
[TD]Shutterfly, Inc.[/TD]
[/TR]
[TR]
[TD]Shutterfly, Inc.[/TD]
[/TR]
[TR]
[TD]Fair Isaac Corporation[/TD]
[/TR]
[TR]
[TD]E2open, Inc.[/TD]
[/TR]
[TR]
[TD]Sybase, Inc.[/TD]
[/TR]
[TR]
[TD]E2open, Inc.[/TD]
[/TR]
[TR]
[TD]Itsi Gilbane Company[/TD]
[/TR]
[TR]
[TD]Epicor Software Corporation[/TD]
[/TR]
[TR]
[TD]Paypal, Inc.[/TD]
[/TR]
[TR]
[TD]Actuate Corporation[/TD]
[/TR]
[TR]
[TD]Linkedin Corporation[/TD]
[/TR]
[TR]
[TD]Actuate Corporation[/TD]
[/TR]
[TR]
[TD]Braden Partners, L.P., A California Limited Partnership[/TD]
[/TR]
[TR]
[TD]Visa International Service Association[/TD]
[/TR]
[TR]
[TD]CBS Interactive Inc.[/TD]
[/TR]
[TR]
[TD]Satellite Healthcare, Inc.[/TD]
[/TR]
[TR]
[TD]El Camino Hospital[/TD]
[/TR]
[TR]
[TD]Mellon Capital Management Corporation[/TD]
[/TR]
[TR]
[TD]It Convergence[/TD]
[/TR]
[TR]
[TD]Triage Consulting Group[/TD]
[/TR]
[TR]
[TD]Linkedin Corporation[/TD]
[/TR]
[TR]
[TD]Littler Mendelson, P.C.[/TD]
[/TR]
[TR]
[TD]Netsuite, Inc.[/TD]
[/TR]
[TR]
[TD]Armanino McKenna LLP[/TD]
[/TR]
[TR]
[TD]Visa International Service Association[/TD]
[/TR]
[TR]
[TD]Linkedin Corporation[/TD]
[/TR]
[TR]
[TD]Littler Mendelson, P.C.[/TD]
[/TR]
[TR]
[TD]Symphony Teleca Corporation[/TD]
[/TR]
[TR]
[TD]Symphony Teleca Corporation[/TD]
[/TR]
[TR]
[TD]Erm-West, Inc.[/TD]
[/TR]
[TR]
[TD]Good Technology, Inc.[/TD]
[/TR]
[TR]
[TD]Good Fellow Top Grade Construction, LLC[/TD]
[/TR]
[TR]
[TD]Good Fellow Top Grade Construction, LLC[/TD]
[/TR]
[TR]
[TD]Quicksort, Inc.[/TD]
[/TR]
[TR]
[TD]Quicksort, Inc.[/TD]
[/TR]
[TR]
[TD]T. Y. Lin International[/TD]
[/TR]
[TR]
[TD]Intelliswift Software, Inc.[/TD]
[/TR]
[TR]
[TD]Good Technology, Inc.[/TD]
[/TR]
[TR]
[TD]Trulia, Inc.[/TD]
[/TR]
[TR]
[TD]Cypress Security, LLC[/TD]
[/TR]
[TR]
[TD]Digital Realty Trust, Inc.[/TD]
[/TR]
[TR]
[TD]Cloudera, Inc.[/TD]
[/TR]
[TR]
[TD]Orrick, Herrington, Sutcliffe LLP[/TD]
[/TR]
[TR]
[TD]Akqa, Inc.[/TD]
[/TR]
[TR]
[TD]Rovi Corporation[/TD]
[/TR]
[TR]
[TD]Quinstreet, Inc.[/TD]
[/TR]
[TR]
[TD]Orrick, Herrington, Sutcliffe LLP[/TD]
[/TR]
[TR]
[TD]The Facebook Inc[/TD]
[/TR]
[TR]
[TD]Wildfire Interactive Inc.[/TD]
[/TR]
[TR]
[TD]Lucasfilm Ltd., Llc.[/TD]
[/TR]
[TR]
[TD]Guidewire Software, Inc.[/TD]
[/TR]
[TR]
[TD]Linkedin Corporation[/TD]
[/TR]
[TR]
[TD]First Republic Bank[/TD]
[/TR]
[TR]
[TD]Bkf Engineers[/TD]
[/TR]
[TR]
[TD]The PMI Group Inc[/TD]
[/TR]
[TR]
[TD]Astreya Partners, Inc.[/TD]
[/TR]
[TR]
[TD]Gracenote, Inc.[/TD]
[/TR]
[TR]
[TD]Techlink Systems, Inc.[/TD]
[/TR]
[TR]
[TD]Wested[/TD]
[/TR]
[TR]
[TD]Orrick, Herrington, Sutcliffe LLP[/TD]
[/TR]
[TR]
[TD]Vista Equity Partners LLC[/TD]
[/TR]
[TR]
[TD]Atr International, Inc.[/TD]
[/TR]
[TR]
[TD]Orrick, Herrington, Sutcliffe LLP[/TD]
[/TR]
[TR]
[TD]Orrick, Herrington, Sutcliffe LLP[/TD]
[/TR]
[TR]
[TD]Bre Properties, Inc.[/TD]
[/TR]
[TR]
[TD]Taos Mountain, Inc.[/TD]
[/TR]
[TR]
[TD]Sedgwick LLP[/TD]
[/TR]
[TR]
[TD]Exponent, Inc.[/TD]
[/TR]
[TR]
[TD]Linkedin Corporation[/TD]
[/TR]
[TR]
[TD]Structural Integrity Associates, Inc.[/TD]
[/TR]
[TR]
[TD]Protiviti Inc.[/TD]
[/TR]
[TR]
[TD]Liveops, Inc.[/TD]
[/TR]
[TR]
[TD]Epocrates, Inc.[/TD]
[/TR]
[TR]
[TD]Servicesource International, Inc.[/TD]
[/TR]
[TR]
[TD]Ehealthinsurance Services, Inc.[/TD]
[/TR]
[TR]
[TD]Risk Management Solutions, Inc.[/TD]
[/TR]
[TR]
[TD]Pdf Solutions, Inc.[/TD]
[/TR]
[TR]
[TD]Informatica Corporation[/TD]
[/TR]
[TR]
[TD]Linkedin Corporation[/TD]
[/TR]
[TR]
[TD]Actividentity, Inc.[/TD]
[/TR]
[TR]
[TD]Liveops, Inc.[/TD]
[/TR]
[TR]
[TD]Yodlee, Inc.[/TD]
[/TR]
[TR]
[TD]Extend Health, Inc.[/TD]
[/TR]
[TR]
[TD]Linkedin Corporation[/TD]
[/TR]
[TR]
[TD]Genomic Health, Inc.[/TD]
[/TR]
[TR]
[TD]Informatica Corporation[/TD]
[/TR]
[TR]
[TD]Tectura Corporation[/TD]
[/TR]
[TR]
[TD]Mid-Peninsula Housing Management Corporation[/TD]
[/TR]
[TR]
[TD]CBS Interactive Inc.[/TD]
[/TR]
[TR]
[TD]Informatica Corporation[/TD]
[/TR]
[TR]
[TD]Burr Pilger Mayer, Inc.[/TD]
[/TR]
[TR]
[TD]Symphony Teleca Corporation[/TD]
[/TR]
[TR]
[TD]Freeborders, Inc.[/TD]
[/TR]
[TR]
[TD]Splunk Inc.[/TD]
[/TR]
[TR]
[TD]Linkedin Corporation[/TD]
[/TR]
[TR]
[TD]Actuate Corporation[/TD]
[/TR]
[TR]
[TD]Celera Corporation[/TD]
[/TR]
[TR]
[TD]Actuate Corporation[/TD]
[/TR]
[TR]
[TD]Sybase, Inc.[/TD]
[/TR]
[TR]
[TD]Brown and Caldwell[/TD]
[/TR]
[TR]
[TD]Loopnet, Inc.[/TD]
[/TR]
[TR]
[TD]Serena Software, Inc.[/TD]
[/TR]
[TR]
[TD]Burr Pilger Mayer, Inc.[/TD]
[/TR]
[TR]
[TD]Netsuite, Inc.[/TD]
[/TR]
[TR]
[TD]Symphony Teleca Corporation[/TD]
[/TR]
[TR]
[TD]Golden Rain Foundation of Walnut Creek[/TD]
[/TR]
[TR]
[TD]Symphony Teleca Corporation[/TD]
[/TR]
[TR]
[TD]First Republic Bank[/TD]
[/TR]
[TR]
[TD]E2open, Inc.[/TD]
[/TR]
[TR]
[TD]Fair Isaac Corporation[/TD]
[/TR]
[TR]
[TD]CBS Interactive Inc.[/TD]
[/TR]
[TR]
[TD]Liveops, Inc.[/TD]
[/TR]
[TR]
[TD]Brown and Caldwell[/TD]
[/TR]
[TR]
[TD]Shutterfly, Inc.[/TD]
[/TR]
[TR]
[TD]American Baptist Homes of The West[/TD]
[/TR]
[TR]
[TD]Fair Isaac Corporation[/TD]
[/TR]
[TR]
[TD]Genomic Health, Inc.[/TD]
[/TR]
[TR]
[TD]The PMI Group Inc[/TD]
[/TR]
[TR]
[TD]Phoenix Technologies Ltd.[/TD]
[/TR]
[TR]
[TD]Workday, Inc.[/TD]
[/TR]
[TR]
[TD]Wageworks, Inc.[/TD]
[/TR]
[TR]
[TD]Informatica Corporation[/TD]
[/TR]
[TR]
[TD]Responsys, Inc.[/TD]
[/TR]
[TR]
[TD]Carmel Partners, Inc.[/TD]
[/TR]
[TR]
[TD]Fenwick & West LLP[/TD]
[/TR]
[TR]
[TD]Marklogic Corporation[/TD]
[/TR]
[TR]
[TD]Workday, Inc.[/TD]
[/TR]
[TR]
[TD]Telecare Corporation[/TD]
[/TR]
[TR]
[TD]Performant Financial Corporation[/TD]
[/TR]
[TR]
[TD]Techlink Systems, Inc.[/TD]
[/TR]
[TR]
[TD]Shutterfly, Inc.[/TD]
[/TR]
[TR]
[TD]The Facebook Inc[/TD]
[/TR]
[TR]
[TD]Satellite Healthcare, Inc.[/TD]
[/TR]
[TR]
[TD]Marketo, Inc.[/TD]
[/TR]
[TR]
[TD]E2open, Inc.[/TD]
[/TR]
[TR]
[TD]San Mateo Credit Union[/TD]
[/TR]
[TR]
[TD]Federal Reserve Bank of San Francisco[/TD]
[/TR]
[TR]
[TD]Norcal Mutual Insurance Co Inc[/TD]
[/TR]
[TR]
[TD]McGrath Rentcorp[/TD]
[/TR]
[TR]
[TD]Mid-Peninsula Housing Management Corporation[/TD]
[/TR]
[TR]
[TD]Samsung Information Systems America, Inc.[/TD]
[/TR]
[TR]
[TD]Actuate Corporation[/TD]
[/TR]
[TR]
[TD]Proofpoint, Inc.[/TD]
[/TR]
[TR]
[TD]Imperva, Inc.[/TD]
[/TR]
[TR]
[TD]Genesys Telecommunications Laboratories, Inc.[/TD]
[/TR]
[TR]
[TD]Extend Health, Inc.[/TD]
[/TR]
[TR]
[TD]Simco Electronics[/TD]
[/TR]
[TR]
[TD]Prologis, Inc.[/TD]
[/TR]
[TR]
[TD]Prologis, Inc.[/TD]
[/TR]
[TR]
[TD]Kelleyamerit Fleet Services Inc.[/TD]
[/TR]
[TR]
[TD]Embarcadero Technologies, Inc.[/TD]
[/TR]
[TR]
[TD]Marklogic Corporation[/TD]
[/TR]
[TR]
[TD]Marketwatch, Inc.[/TD]
[/TR]
[TR]
[TD]Ares Corporation[/TD]
[/TR]
[TR]
[TD]Leisure Sports, Inc.[/TD]
[/TR]
[TR]
[TD]Associated Third Party Administrators Inc[/TD]
[/TR]
[TR]
[TD]Hcl America Inc.[/TD]
[/TR]
[TR]
[TD]Guidewire Software, Inc.[/TD]
[/TR]
[TR]
[TD]Protiviti Inc.[/TD]
[/TR]
[TR]
[TD]Atr International, Inc.[/TD]
[/TR]
[TR]
[TD]Gracenote, Inc.[/TD]
[/TR]
[TR]
[TD]N Model Inc[/TD]
[/TR]
[TR]
[TD]Fireman's Fund Insurance Company[/TD]
[/TR]
[TR]
[TD]Loopnet, Inc.[/TD]
[/TR]
[TR]
[TD]Exponent, Inc.[/TD]
[/TR]
[TR]
[TD]Prologis, Inc.[/TD]
[/TR]
[TR]
[TD]Evans Analytical Group LLC[/TD]
[/TR]
[TR]
[TD]Prologis, Inc.[/TD]
[/TR]
[TR]
[TD]T. Y. Lin International[/TD]
[/TR]
[TR]
[TD]California Physicians' Service[/TD]
[/TR]
[TR]
[TD]Phoenix Technologies Ltd.[/TD]
[/TR]
[TR]
[TD]San Mateo Credit Union[/TD]
[/TR]
[TR]
[TD]Delta Dental of California[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
Sort by date Sort by votes
Have you tried find and replace?
 
Upvote 0
You could use Find & Replace couldn't you?

Find what: L.L.C - Replace with ""

Repeat for the other offending strings.

Regards,
Howard
 
Upvote 0
We have to run about 30 find and replaces in a row to rid them all, is there a more efficient formula to handle this? Thanks for your input!
 
Upvote 0
Yeah, you might want to read the do's and do not's.

You could take the time and use the macro recorder and come up with a comprehensive list of items to replace with "nada".

I ran this on 17 columns over 1100 rows in each column and it took less than a second.

You might note... What:=", inc", I included the comma and the space in the find. The space and L.L.C in the others.
Once done, running on your huge data won't take very long at all, even with 30 different finds. Maybe a few seconds, I did not test that many.

Regards,
Howard

Code: 
Option Explicit
Sub Macro1()
' Macro1 Macro
    Cells.Replace What:=", inc", Replacement:="", LookAt:=xlPart, SearchOrder _
        :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
    Cells.Replace What:=" L.L.C", Replacement:="", LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False
    Cells.Replace What:=" LTD", Replacement:="", LookAt:=xlPart, SearchOrder _
        :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
End Sub
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
Count total award value per unique supplier
Replies
4
Views
204
Fluff
Fluff
C
  • Question Question
Formatting VBA - Why isn't it working on all of them?
Replies
5
Views
511
cjlittlet
C
T
  • Question Question
Formula to Group Companies under Categories
Replies
2
Views
605
alansidman
alansidman
K
  • Solved
Out of my Element, looking for guidance
Replies
7
Views
635
Peter_SSs
Peter_SSs
T
  • Question Question
Need help with writting a macro
Replies
3
Views
1K
JLGWhiz
JLGWhiz

Forum statistics

Threads
1,226,521
Messages
6,191,535
Members
453,662
Latest member
Xcelling

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top