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
================================================== =====
|