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.