flipping a set of numbers

[psrs0810]

What is an easy way to flip a set of numbers?

I have: 12345-9876 and want to flip it to: 9876-12345

I tried =Left and Right, with no success.

thanks

 

[VoG]

Like this?

Excel Workbook
	A	B
1	12345-9876	9876 -12345
Sheet2

 

[stefankemp]

Try this:

=RIGHT(A2,4)&"-"&LEFT(A2,5)

assuming your string is in cell A2, and it always has that format.

 

[psrs0810]

NICE!!!

Thanks

 

[JackDanIce]

Try:

=RIGHT(A1,LEN(A1)-FIND("-",A1))&"-"&LEFT(A1,FIND("-",A1)-1)