I have Extracted names in column A.

DinethPrabash
JohnSmith
WilliamTell
RobinHood

All follow this rule (no three names etc)

I want to replace second capital letter with space (or any other delimiter) and that letter.

e.g. Dineth Prabash
John Smith

So I can use text to column and make it two columns (first name, last name)
can you help me?

better if no macro.