Quote Originally Posted by DMT Dave View Post
I Guess a little button to reverse the name if the surname is left and forename right
Why a button?
Computers are inherently stupid. That is why we program them

Yes I know we have smart devices, I have 5 in my house and when I ask one to switch something on, it tells me it is switching the item off, or device cannot be found. Ask again and it carries out the command.

As long as you can define a rule, you should be OK?

So if the name is Dave, DMT, look for the comma and switch the words. if not found leave it as is.
So yes Instr() would find if a comma, Split() would give you the names and then Trim() if needed would take it from there.

Dave DMT however would not work under those rules. Neither would DMT; Dave, unless you replace ; with a space?

Computers like consistency, or rules as to how that might divert.

As for Google minis, they have a long way to go yet.