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.
Bookmarks