A question about decoding, substitute or vlookup of character.
excel 97
sheet1:
y@o
l$ng
zh#ng
l!
sheet2:
! a
@ i
# o
$ u
decoding sheet1, i want the output to sheet3 be:
yio
lung
zhong
la
is there any easy worksheetfunction to do so?
thanks.
rgds.
alan
--END
|