Have you looked in Excel's Help file? It has some EXCELlent examples.

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"



"still confused" wrote in message
...
thanks for yesterday's help, however, I can not seem to
arrange it to work for what I need. I tried to fill in
the info I am actually using, but I do not understand
enough programming to make it work.

my range is L2:M12
I am using 10 letters to represent numbers 1,2..8,9,0
those letters are to be typed in the "D" column, no more
than 6 consecutive letters (they will not represent a
value greater than $9,999.99

Please help...