Question about macros.

  • Thread starter Thread starter UllSang
  • Start date Start date
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.
 
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
 
If A1 contains 123456 then =LEFT(A1,2) & "," & MID(A1,3,2) & "," & RIGHT(A1,2)

will display:
12,34,56
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting String to pairs. 3
display order of values without sorting 2
Cursor, row, colum, beam 3
Do Loop or use End iF for search string 4
Finding and combining data between two sheets 3
macro that displays function from 2 columns 4
Advanced Text to Columns?? 5
<ASK> How to add columm more than the default columm IV 3

Back
Top