Retaining similar values in cells

Closed
ExcelDoubts - Aug 19, 2010 at 12:18 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 20, 2010 at 08:37 AM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Aug 20, 2010 at 08:37 AM
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
0