I have single (merged) cells that have this pattern:

FirstName (possible MiddleName) LastName (" " OR ", " OR " / ") DD/MM/YY

For example:

John Doe 21/01/2022
John Johasson Doe, 21/01/2022
etc...

I would like to split such cell using VBA and pasting the full name and the date into their own individual cells

The main delimiter here seems to be the date sinceit starts with a number since names can't takes those but I'm not sure how to achieve splitting the cell content.

So far I was using this:

Workbooks(workbook1).Worksheets("sheet").Range("whatever cell num").Value = Split(Workbooks(workbook2).Worksheets("sheet").Range("whatever cell num").Value, ", ")(0)
    Workbooks(workbook1).Worksheets("sheet").Range("whatever cell num").Value = Split(Workbooks(workbook2).Worksheets("sheet").Range("whatever cell num").Value, ", ")(1)

It used to work fine for its purpose until I started coming across signatures that don't involve commas to separate names and dates

Is there a solution that doesn't involve creating a function a looping through the string?