Manipulating strings

Hey there, I have a excel sheet where I have a list of strings seperated by a "-". I am looking to take the particular cell value and swap the characters before the dash with the characters after the dash. So for example:


FG03-FJ04 would become FJ04-FG03
AB02-CD12 would become CD12-AB02 and so forth....

I have tried findling around with the split function but cant seem to get anywhere, does anyone know a tried and tested method of doing this? I would normally attach an excel sheet but I feel this might not be neccesary, although I could attach an example if requested.

Thanks for your help,

Jag

If your data is always of that format, then Split should work:

Please Login or Register  to view this content.

for example.