Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Filtering part of text
I have a list of email addresses.
I want to delete those email addresses that have these letters: cpf for example or How to do this? |
#2
|
|||
|
|||
Use datafilterauto filter, from dropdown select custom and contains and in
the box put cpf. filter, then select the visible area, press F5, click special and select visible cell only then press ctrl - from the dropdown select show all -- Regards, Peo Sjoblom (No private emails please) "Happy" wrote in message ... I have a list of email addresses. I want to delete those email addresses that have these letters: cpf for example or How to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtering out text with conditional formatting | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions | |||
How do I test a cell for part of text | Excel Worksheet Functions | |||
Count the text in a column - Part II | Excel Discussion (Misc queries) |