How to change the arrangement of numbers and symbols in a cell

Ok, is there a way to change this within the same cell?

Example:

1800 (70.87")
to
70.87 (1800)


I can do this with text to columns and find/replace but I was hoping for a formula to expedite. Thanks!

Try this:

=SUBSTITUTE(RIGHT(A2,LEN(A2)-FIND("(",A2)),CHAR(34)&")","")&" ("&LEFT(A2,FIND(" (",A2)-1)&")"

assuming the original value is in A2.

Hope this helps.

Pete

=substitute(mid(a1,find("(",a1)+1,len(a1)),right(a1,2),"")&"("&left(a1,find("(",a1)-1)&")"

Wow!! It is absolutely amazing the things you can do with Excel. Love it! Thank you so much, Pete !!!

Thank you too, Ghozi! I appreciate such quick responses!

Originally Posted by Ghozi Alkatiri

=substitute(mid(a1,find("(",a1)+1,len(a1)),right(a1,2),"")&"("&left(a1,find("(",a1)-1)&")"

Need some spaces in your formula or the output looks funny The Stars are were the spaces need to be.

Please Login or Register  to view this content.