I explored a lot on internet for a customized formula which can reverse the digits in a cell and found many solutions using VBA user defined function or by installing add-in but couldn't find any help with excel formula. So here is the formula for it that I developed after 3 hours of struggle:)
=SUMPRODUCT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)*1,POWER(10,ROW(INDIRECT("1:"&LEN(A1)))-1))
Please post in comment section if you have some other short and simple way to do it.
Thanks!
Good One Shweta
ReplyDeleteThis comment has been removed by a blog administrator.
ReplyDelete