If cell A1 contains Alfa numeric text for example “1X”, “ 5X”, “15Y”, “16Y” ,“(ANY NUMBER )X”, “(ANY NUMBER)Y”
Result:
Cell B1 should display “1Y”, “ 5Y”, “15X”, “16X” ,“(ANY NUMBER )Y”, “(ANY NUMBER)X”
I would like to display same numeric data as Cell A1 in Cell B1 but if it is X with number replace with Y and If it is Y with number replace with X..
Thanks.
Bookmarks