Can excel search for only cells with '@'? Closed

Question

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

Configuration: Windows Vista / Firefox 3.6.8

venkat1926 · Answer

edit find (control+F)
type @ in find what
click options at tbe bottom
uncheck match case and match entire cell contents 
click find next

suff954 · Answer

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

Can excel search for only cells with '@'?

2 responses

Similar discussions

Subscribe To Our Newsletter!