Excel loop, inner loop [Closed]

Report
-
 WutUp WutUp -
Hello,
I have an excel file that has data in a cell that looks like "abcd-123456-efghijk-7890". My problem is that i have about 2000 of this type of data (exact same format) in one column. I would like to write a loop and inner loop and goes through all the active columns and just copies "abcd" and pastes it into column +1, copies 123456 and pastes into column +2, copies "efghijk" and pastes into column +3, and copies "7890" and pastes in coumn +4. I am an excel vba newbie and any help would be greatly appreciated.

1 reply

The data you are speaking of, what column is it in? You want all the data separated in the columns beside it, or another sheet?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!