Manipulate String format

[apo]

Hi..

I have been trying to crack this for a day now.. any help would be greatly appreciated.

I have a column of Descriptions (Column C). These are all descriptions of PDF Filenames.

I am trying to make a Macro where each Description in Column C is looked for on my hard drive and the row highlighted yellow if it finds the file.

I have got the part where it looks on my hard drive and then colors the row yellow done fine... the issue i am facing is that the Descriptions entered in Column C quite often don't have the exact correct filename.

Example:

BH100212.2-12.48_UCS-samplesent_awaytoABTF Should search for: BH100212.20-12.48_UCS-samplesent_awaytoABTF BH10037.3-7.55_UCS-samplesent_awaytoABTF Should search for: BH100307.30-07.55_UCS-samplesent_awaytoABTF Basically.. after the first 6 characters.. the format then needs to be xx.xx-xx.xx The leading zeros must be present so the search matches up with the filename.. Anyone got any idea how to manipulate those numbers after the first 6 characters so they get the zeros added? <tbody> </tbody> <tbody> </tbody> <tbody> </tbody>

<tbody>
</tbody>

 

[sergioMabres]

yes I can think on how to manipulate but I do not think you can came with an algorithm to guess if zeros are trailing or ending 2-> 20 and 7 -> 07
Sergio