Question about macros.

U

UllSang

hello i have a file that was pre generated for me. it contains many
colums and rows.
a certian colum constains a string of 6 digits, like 272829 and 359514
and so on. I need those split up into pairs, either by comma or
something else so i can do a find and replace.
so it could look like 27,28,29 and 35,95,14. Any suggestions for how i
can automate it. I regularaly get theses lists and they contain 1200+
rows. it takes me hours. thanks for your help.
 
C

CLR

Assuming your numbers are in column A, put this formula in a helper column
and copy down.........

=LEFT(A1,2)&","&MID(A1,3,2)&","&RIGHT(A1,2)

Vaya con Dios,
Chuck, CABGx3
 
G

Gary''s Student

If A1 contains 123456 then =LEFT(A1,2) & "," & MID(A1,3,2) & "," & RIGHT(A1,2)

will display:
12,34,56
 
Top