Hi All,
I have a list of 35,000 accounts, with details of name, contact phone, residential address, postal address, etc as the column headers/fields.
As part of tidying up our database I need to fix up silly things like having "Po Box 1234" listed as the residential address instead of "PO Box 1234".
I've had a look at the EXACT function and custom filters (ie using wildcards such as '?' and '*'), however can't figure out how to combine the two. Basically, I want to filter so that I only see records that BEGIN WITH "Po" - I do not want to see records that begin with "PO".
Any advice on how to tackle this?
Had a bit of a search of the forums but couldn't find what I was after - if the info is in another post please feel free to direct me that way and I'll close this thread.
Cheers!
Rob.
Bookmarks