weenie
07-07-2017, 01:05 PM
Hello,
Using Excel 2007. I have data in Col. B that will always have 12 characters (characters will always vary).
1) How do I add dashes & period at specific spots in name Col B cell 2
2) then copy this new name all way down to last cell in col B?
Example:
417331450200
I want to add two dashes & one period 417-33-1450.200
Then take new name & copy down to last cell of column.
I don't need it to loop.
I have no idea how to write vb code to add these characters.
Thanks,
weenie
Using Excel 2007. I have data in Col. B that will always have 12 characters (characters will always vary).
1) How do I add dashes & period at specific spots in name Col B cell 2
2) then copy this new name all way down to last cell in col B?
Example:
417331450200
I want to add two dashes & one period 417-33-1450.200
Then take new name & copy down to last cell of column.
I don't need it to loop.
I have no idea how to write vb code to add these characters.
Thanks,
weenie