MrExcel Publishing
Your One Stop for Excel Tips & Solutions

I need a simple logic formula


Posted by Ross Taylor on January 11, 2001 8:42 AM

I have a column containing a list of 2 similar types of text entry (eg A1 contains 'usa' A2 contains 'usalanguage'. The list is fairly long.

I am trying to get a formula/macro that deletes any cells containing the word 'language' so I would be left with only the 'usa' cell. Eg
A1=usa
A2=usalanguage
A3=gb
A4=gblanguage
should be 'cleaned up' to appear as:
A1=usa
A2=gb

If anyone can suggest anything, or give me hints, I would appreciate it.


Posted by Mark W. on January 11, 2001 9:08 AM

Use an AutoFilter on the list. Filter those record
that are 'equal' '*language', delete the displayed
rows, and remove the AutoFilter.

Posted by Ross Taylor on January 12, 2001 1:52 AM

Thanks a lot, that had never occurred to me!