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!
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
Thank you too, Ghozi! I appreciate such quick responses!
=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 !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks