Find Start Position of Date within a String

[patrisk]

I am trying to use FindString to determine the the position of the date in below string. Date is always formatted as DD/MM/YYYY, however, length of string before date may vary.

Akt HEIWA REAL ESTAT 29/01/2021 M 187.000000JPY 114.688541 125,269.80 9,015.00 0.00 0.00

Underlying goal: Text to column, keeping string prior to date "as one", splitting at space between "Akt HEIWA REAL ESTAT" and "29/01/2021".

[binuacs · Accepted solution]

@patrisk 

[patrisk]

Works like a charm! Appreciate it