Personally, I'm still not following what you are trying to do. Is there
anyway you can give an example string with real data and not spaces, dots,
underlines, etc.; and then show us how you want that "translated" and where
you want that translation to go?

--
Rick (MVP - Excel)


"tom_mcd" wrote in message
...
sorry for being a bit vague

1st string would be cell A1, 2nd string would be A2 etc.
I would like to replace each character in each string with its number in
the
string. For e.g cell B1 the first . would become 1, cell B2 would become
2 .
but I want to keep the letters. so cell B14 would still be L, B16 would
still
be L but cell B19 would be 19.
Is this any clearer. I've got a lot of data from a personnel system that
I've got to analyse and it's in the above format.

Thanks for having a look

"tom_mcd" wrote:

..........<__LLLL......<__..........<__........ ..<__..
........LL<__LL........<__..........<__........ ..<__..
..........<__LL........<__..........<__........ ..<__..
HI all, above is a string with each character representing a date in a
month. I would like to be able to repalce each character with a number.
For
e.g. in the first string the 1st < would be number 11, the 1st L would be
number 14 etc.They would also be in separate cells. Any ideas. Thaks
again in
anticipation. Regards