View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HARSHAWARDHAN. S .SHASTRI[_2_] HARSHAWARDHAN. S .SHASTRI[_2_] is offline
external usenet poster
 
Posts: 69
Default IS IT POSSIBLE IN EXCEL WITHOUT WRITING CODE.

Dilip Pandeji,

Bahot khub.very very good.

Thanks.

H S Shastri

================================================== =======

"DILipandey" wrote:

Hello Shastri Ji..!!

Try following:-
{=SUM(VALUE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)) *10^(ROW(INDIRECT("1:"&LEN(A1)))-1))}
Thanks.
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)


New Delhi, India


"HARSHAWARDHAN. S .SHASTRI" wrote:


What i need is "FLIXER" Value.

FLIXER value means reverse digit.

i e FLIXER value of 123 will be 321 , FLIXER value of 12121212 will be

21212121 like that.

Awaiting quick response.

H S Shastri

================================================== =====