adding CSV to a cell

ango858

New Member
Joined
Mar 22, 2011
Messages
29
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.
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Tuelor

Board Regular
Joined
Mar 19, 2011
Messages
101
Would a find and replace do it? For example if you searched for "d" and replaced it with "d,"?

D
 

xizhenyan

New Member
Joined
Aug 15, 2005
Messages
19
I have written a macro in Excel 4.0 Macro. I am sorry to use this old version because I cannot use VBA.

I would like to give you the macro I wrote, but I cannot find an attach button here.

You can use for_next and Mid(.....) to find the lettters one by one and to add a comma befor each letter.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,614
Messages
5,523,906
Members
409,542
Latest member
Shezz01

This Week's Hot Topics

Top