View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tom_mcd[_2_] tom_mcd[_2_] is offline
external usenet poster
 
Posts: 12
Default len replace function

...........<__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