Take a value in a cell and manipulate it so that
in cell A2 value 503123 becomes cell B2 value F03123
where leading character is all that is manipulated
0=A, 1=B, 2=C, 3=D, 4=E, 5=F, 6=G, 7=H, 8=I, 9=J
Any help appreciated, thanks in advance.
Take a value in a cell and manipulate it so that
in cell A2 value 503123 becomes cell B2 value F03123
where leading character is all that is manipulated
0=A, 1=B, 2=C, 3=D, 4=E, 5=F, 6=G, 7=H, 8=I, 9=J
Any help appreciated, thanks in advance.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks