This script gives you several ways to edit the text of the Artist tag of a selection of tracks. You can do one of either:
Remove the LAST word of the Artist tag to the beginning, eg:
OR Remove the FIRST word of the Artist tag to the end, eg:
Additionally, the newly configured text can be copied to your choice of Artist, Album Artist, Sort Artist and/or Sort Album Artist tags.
I would use this script on a small number of tracks at a time, perhaps on a single album or a selection of same-artist tracks. To be safe.
Select some tracks and launch; choose the format (here, "Last Word to Front" is chosen); then choose which tags get the edited artist tag text.