Excel loop, inner loop
Closed
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.
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.
Related:
- Excel loop, inner loop
- Fruity loop download - Download - Musical production
- Game loop - Download - Android emulators
- Microsoft loop - Download - Organisation and teamwork
- Discord update failed loop - Guide
- Excel mod apk for pc - Download - Spreadsheets