hi ppl,
please help me to solve the splitting problem.
how to split 1 ~ 3, 4, 5 in to rows with each cell each number.
example :
From: A 1~3, 4, 5
To : A 1
A 2
A 3
A 4
A 5
thanks
hi ppl,
please help me to solve the splitting problem.
how to split 1 ~ 3, 4, 5 in to rows with each cell each number.
example :
From: A 1~3, 4, 5
To : A 1
A 2
A 3
A 4
A 5
thanks
hi - a few questions
- is the string to split contained in a single cell or successive ones?
- are the characters to split separated by commas, spaces or other characters?
- what does this symbol represent - " ~ "
hi,
thanks to your response,
1. all the data original in one cell, which mean 1~3, 4, 5 in one cell. i wan to separate these numeric data into multiple cell such like 1~3, 4, 5 to 1 2 3 4 5 for each cell
2. each number is separate by commas
3. ~ mean continuous number. which mean 1 ~ 3 = 1 till 3 = 1 2 3
thanks
hi
try this macro
Please Login or Register to view this content.
Hi jmloo80
I am assuming you mean that you have a cell that has: 1,2,3,4,5 !
If so, assuming the cell in question is A1, then try this formula, say in cell B1 and copy down..
Formula:Please Login or Register to view this content.
Regards Kevin
Merged Cells (They are the work of the devil!!!)
hi NickyC,
the macros works..... thanks a lot.
hi kelvin,
thanks to your help too
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks