Getting a string array?

Hi,

I am writing a addin toolbar in excel VBA.

When I get a cell and the text inside, I want to compare the the text to replace it with something else.

Eg. 27d8'35.7807" must be replaced with 27d08'35.7807"

So I want to check for: after 'd' and before ' for a single digit and replace it with a 0 and the digit.

Thats why I thought of using a string array. By putting the text of the cell in the string in the array and testing for a d and a '

But the cell text must be in a object and if I use

Please Login or Register  to view this content.

c(1).Text is also the whole cell
and I suspected it to be (like in the eg.) only 7

Can anyone tell me how can I loop through the cell contents one digit at a time.

No, the position d will always be 3rd.

Thank for all your help

Thanks, it works perfectly.

Now I at least have something to work with.
Thanks again