Retaining similar values in cells

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I need a solution with retaining similar values in excel sheets. I have a list of words like:

Mount Prospect IL Multi-Family Mortgages
Mount Prospect IL Multi-Family Mortgages
Mount Prospect IL Section 1031 Mortgages
Mount Prospect IL Section 1031 Mortgages
Port St Lucie Home Equity Conv Mortgages
Port St Lucie Home Equity Conv Mortgages
Redondo Beach Home Equity Conv Mortgages
Redondo Beach Home Equity Conv Mortgages
Mount Prospect IL Conventional Mortgages
Mount Prospect IL Conventional Mortgages


Now, I want to delete all the place names while retaining the types of mortgages... w/o having to use text filters for each category, because thats a relatively slow option. How do I do that? The end result should be:

Multi-Family Mortgages
Multi-Family Mortgages
Section 1031 Mortgages
Section 1031 Mortgages
Home Equity Conv Mortgages
Home Equity Conv Mortgages
Home Equity Conv Mortgages
Home Equity Conv Mortgages
Conventional Mortgages
Conventional Mortgages

Thanks! :)

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
A N D post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!