how to reverse words in excel
hello everyone
I have a few thousand titles that I want to rename.
The problem here is that I can't find the right way to rename them correctly without ruining the title in general because then to rename again by the correct name is very difficult
for example the last 3 titles in the photo are
Zun - Trees of Tampa, ACID FLORA (Mira & Chris Schwarzwalder Remix)
Zemer - Montw, Moodintrigo (Hobin Rude Remix)
Zemer - Montw, Moodintrigo (HAFT Remix)
but must be
Trees of Tampa, ACID FLORA - Zun (Mira & Chris Schwarzwalder Remix)
Montw, Moodintrigo - Zemer (Hobin Rude Remix)
Montw, Moodintrigo - Zemer (HAFT Remix)
I want to change the word between - )
there is anyone who knows how to do this?
In the end everything will be like this
Montw & Moodintrigo - Zemer (Hobin Rude Remix)
[link] [comments]
Want to read more?
Check out the full article on the original site