Search:

The mid example works perfect for values after the first dash, but I still haven't figured out how to alter it to work for the next section after the second dash.

The best I've done is to use;
...

Man that's brilliant. The Mid example works spot on as is! I've just got to try & figure out how it works now so I can alter it for the next section after the second dash (-). Too good. Very happy.

Thanks Man!:)

Awesome!!

:):):)

Hi,

I have a field (Tag_Num) in an Access database that contains a heap of values that look something like this;

12345-1234-ABC-40-CG1
12345-2868-ACC-40-CG1
12345-4897-ACC-40-CG1...

Hi Guys,

As per the example below, I have two columns (A & B) which I have that are to be joined along with a sequential number to make up part of a final number (column C). Columns A & B need to...