Can excel search for only cells with '@'?

Closed
Report
-
 Blocked Profile -
Hello,

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?

Thanks!

Stephen

2 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
edit find (control+F)
type @ in find what
click options at tbe bottom
uncheck match case and match entire cell contents
click find next

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,

Thanks