Change the order of a double barrelled surname

[EmmaTM]

Hi , I am looking for a simple way to change the order of a double barrelled surname.
For example if in my list of names I have Smith-Jones, I want to be able to swap that to Jones-Smith. I may have multiple names in the list.

Thank you

 

[denzo36]

Many ways to do this but would need to see some sample data as we don't know what delimiters may occur. Also please tell us which version of excel you have

thanks

 

[Peter_SSs]

Also please tell us which version of excel you have

Have a look at the OP's details at the left of their post.

@EmmaTM
If your data contains just surnames, then try this. Otherwise please give us some varied but realistic sample data and expected results, preferably with XL2BB

23 12 08.xlsm
	A	B
1	Smith-Jones	Jones-Smith
2	Hall	Hall
Swap

Cell Formulas
Range	Formula
B1:B2	B1	=MID(A1&"-"&A1,FIND("-",A1&"-")+1,LEN(A1))

 

[EmmaTM]

Thank you that has worked

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.