how to create add a csv to a cell (excel 2007)

[ango858]

in one cell I have data such as:

d10d100i01d09d07i04

and i am hoping to to add a comma before each letter so that it appears like this:
d10,d100,i01,d09,d07,i04

i dont mind if it has to add a comma before the first one either:
,d10,d100,i01,d09,d07,i04

i have a lot of data like this and need to be able to loop it, however if someone can get me on the right path with adding the commas i should be able to manage the rest.


thanks in advance.

 

[ango858]

bump

 

[ango858]

anyone?