View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default IS IT POSSIBLE IN EXCEL WITHOUT WRITING CODE.

With a value in A1, in B1 enter:

=IF(ISERROR(MID(A$1,LEN(A$1)+1-ROW(),1)),"",MID(A$1,LEN(A$1)+1-ROW(),1))
and copy down until blanks appear

In C1, enter:

=B1

In C2, enter:

=C1 & B2 and copy down. Here is an example:

qwerrty y y
t yt
r ytr
r ytrr
e ytrre
w ytrrew
q ytrrewq

--
Gary''s Student - gsnu200831


"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

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