Hi
Try the following code. It only works for cells with the formats:
<numbers<characters
but that's a starting point.
--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"Jo Ke" wrote:

I know that Excel will allow separate formatting of data within a cell
(i.e. "37715CCC", where the numbers ("37715") are "blue" & "bold" and
the letters ("CCC") are "black", "bold" & "italic") ., but is there a
way (VBA) of going thru a selection of cells, finding the letters,
make them "blue" & "bold" and the numbers "black", "bold" & "italic".?
I'm just trying to make the alphanumeric data easier to read (you know
distinguishing "O" from "0").