just wondering if anyone can help me with excel formula
1 5 9
2 6 10
3 7 11
4 8 12
convert to
1
2
3
4
5
6
7
8
9
10
11
12
1 5 9
2 6 10
3 7 11
4 8 12
convert to
1
2
3
4
5
6
7
8
9
10
11
12
EXCEL Automation
- Thread starter formosaz
- Start date
Not sure how many rows of data you have so this might not work too well but assuming that all your data is in a single column (with characters/digits separated by a space), then the first thing you should get friendly with notepad and the find/replace function:
1) Copy data into notepad
2) Run find/replace to swap spaces with tabs
3) Paste the data back into Excel as columns
4) Copy data from columns B and C, and append it to column A
Not sure if that's what you meant?
1) Copy data into notepad
2) Run find/replace to swap spaces with tabs
3) Paste the data back into Excel as columns
4) Copy data from columns B and C, and append it to column A
Not sure if that's what you meant?
