I am trying to do something similar, but i am having troubles. I have a cell that has "WL" and I want the cell next to it to substitute all of the "W" for "L" and "L" for "W" so it would appear as "LW". How would I go about doing this. The formula i tried looks like this with J44 being the cell that says WL... =SUBSTITUTE(SUBSTITUTE(J44,"L","W",),"W","L") Thanks in advance!
Hi dompoma,
See the attached file where I have given two options in yellow and green cells.. thanks.
Attachment 161284
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Hi Dompoma,
Perhaps add an intermediate substitute like so:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"W","B"),"L","W"),"B","L")
Convert W's to B's, then L's to W's, then B's to L's.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks