Validate existing data

[joannasstudio]

I have downloaded 40,000 records for my company. I need to validate that data in certain fields are correct, before I can upload it into access. For instance, i need to validate that the email feild is all xxx@x.xxx how do i do this?

 

[Faseeh]

Hi joannasstudio,


If you wan to validate only the "@x.xxx" portion of an email id then you simply highlight it using conditional formatting > Highlight Rule > Text that contain and put "@x.xxx", this will highlight the cells with this id.


Regards,

 

[Dhamo]

Hi joannasstudio,


Excel has other option too, If you want to validate only the "@x.xxx" portion of an email id then you simply find (Ctrl+F) the string "@x.xxx" and click on 'Find All', It will display total number of cell(s) found in the 'Find dialog box's status bar.


If it is 40,000 then all records are having @x.xxx portion in the emails.

 

[joannasstudio]

That is helpful, but I want to find the ones that are NOT formatted like that, so I can fix them.

 

[joannasstudio]

actually the conditional formatting worked fine! I was able to find incorrect emails! Thanks!