Hi All - New to the thread. I have a data set (image below) and I'm hoping to find a way either through a formula or conditional formatting to identify lines not following our invoice number convention (USINV-######) and requiring massaging prior to upload.
InvoiceNumbers.JPG
Bookmarks