Can excel search for only cells with '@'?

Stephen - Sep 12, 2010 at 11:06 PM
 Blocked Profile - Sep 13, 2010 at 08:33 AM

I have a large spreadsheet of contact info and am looking to extract only cells with the '@' symbol in them, as these will all be email addresses which is the data I need. Is there a way to extract only the cells with the '@' in them?




2 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 13, 2010 at 07:00 AM
edit find (control+F)
type @ in find what
click options at tbe bottom
uncheck match case and match entire cell contents
click find next
Blocked Profile
Sep 13, 2010 at 08:33 AM
Hi there,

Try this:

Make your selection of the data ,selecting all then go to data tab>text to columns>select delimited press next then check 'tab and other ,in other enter @ symbol,press next then finish,