Convert Range Cell Of Text Into Proper Date

Hi,

I would like to know how can I convert a column P and T that contains these type of number into a proper way of date of DDMMMYYYY.

Like, if the cell in the column P has 8 digits then convert
19830425 -> 25APR1983
19910515 -> 15MAY1991
next cell till end of column P.
Then do the same to column T.

Thanks.

Hi,

I know the formula, but how to make it macro?
1 click and done.

Thanks.