Hi,

In A1:A1000 I have in each cell a text string in the form:

Text / MM/DD/YYYY / Text

An example would be:

John / 07/23/2019 / Smith

The middle 10 characters represents the date in US format.

Can someone please tell me a formula that will convert the date in this string from US (MM/DD/YYYY) to UK (DD/MM/YYYY) form?

Thanks!