daddylonglegs Wrote:
Try this formula solution

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A5,0,2),1,0),2,1 )


Thank you very much "DADYLONGLEGS", you have suggested me one of the
simplest option very useful in my application.


Thanks & Regards,
-----------------
Aashu


--
Aashu
------------------------------------------------------------------------
Aashu's Profile: http://www.excelforum.com/member.php...o&userid=36916
View this thread: http://www.excelforum.com/showthread...hreadid=566643