Hi Moo... thanks for your response and for taking the time to look at my issue. Most kind.

If you see my helper cols, e, f and g, and then the concatenation of e, f and g in col h. This is what i am trying to achieve but in the format of col I.

Basically... it the first two characters of col a, col b as a number and the last two characters of col c. to make a date formatted as dd/mm/yy

Is that clear?

Many thanks again for looking