I often need to copy and paste names from one app to another, and the names need to be inverted when pasted. So, for example, John Smith needs to become Smith, John.
Is there a way to create a macro for this? How much of this can the macro do? The most useful portion for me would be to invert the name. Can the macro also automatically paste in the appropriate app?