I have sheet with lots of stocks buy and sell info. example
apple buy 100 $150
apple sell 100 $150
blackberry buy 120 $12
Microsoft buy 200 $25
apple buy 100 $150
blackberry sell 120 $12
Microsoft sell 200 $25
I want to separate and copy all the above...
I have field with phone numbers in following format
123-1234-1234
however there are some records that are not in that format like
1234567890
also there are some records that are repeat of same numbers
111111111
i want to write query in design mode that will isolate these bad records that are...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.