software

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.Assuming your numbers are in column A, put this formula in a helper column
and copy down.........

=LEFT(A1,2)amp;quot;,quot;amp;MID(A1,3,2)amp;quot;,quot;amp;RIGHT(A1,2)

Vaya con Dios,
Chuck, CABGx3
quot; wrote:

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

If A1 contains 123456 then =LEFT(A1,2) amp; quot;,quot; amp; MID(A1,3,2) amp; quot;,quot; amp; RIGHT(A1,2)

will display:
12,34,56
quot; wrote:

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

Another way

=TEXT(A1,quot;##quot;quot;,quot;quot;##quot;quot;,quot;quot;##quot;)

copy down the formula, copy the help range and paste special as values in
place
delete the import

--

Regards,

Peo Sjoblom

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