S
Shannyduck
Please help as soon as possible...
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
Please explain what you want. Quickly now.
D
Duke Carey
We cannot help you unless you provide a decent explanation of what you are
trying to accomplish!!
trying to accomplish!!
D
David Billigmeier
So confusing what you actually want done. Care to offer a little bit more to
go on?
go on?
S
Shannyduck
Sorry.. first time that I have had to this..
I have a badly made spreadsheet which features mutliples figures of text
(i.e. groups of numbers in one cell). I need to get each number seperated
out into it's own row.
Basically, I am looking for a function that works exactly like the "text to
columns" function / but is "text to rows".
Hope that makes sense.. thanks for your help!
I have a badly made spreadsheet which features mutliples figures of text
(i.e. groups of numbers in one cell). I need to get each number seperated
out into it's own row.
Basically, I am looking for a function that works exactly like the "text to
columns" function / but is "text to rows".
Hope that makes sense.. thanks for your help!
D
David Billigmeier
Use the text to columns feature to get the data to it's own column. Then,
select the data and "Paste Special"->Transpose to get it into rows
select the data and "Paste Special"->Transpose to get it into rows
S
Shannyduck
Sorry.. first time that I have had to this..
I have a badly made spreadsheet which features mutliples figures of text
(i.e. groups of numbers in one cell). I need to get each number seperated
out into it's own row.
Basically, I am looking for a function that works exactly like the "text to
columns" function / but is "text to rows".
Hope that makes sense.. thanks for your help!
I have a badly made spreadsheet which features mutliples figures of text
(i.e. groups of numbers in one cell). I need to get each number seperated
out into it's own row.
Basically, I am looking for a function that works exactly like the "text to
columns" function / but is "text to rows".
Hope that makes sense.. thanks for your help!
S
Shannyduck
Sorry.. first time that I have had to this..
I have a badly made spreadsheet which features mutliples figures of text
(i.e. groups of numbers in one cell). I need to get each number seperated
out into it's own row.
Basically, I am looking for a function that works exactly like the "text to
columns" function / but is "text to rows".
Hope that makes sense.. thanks for your help!
I have a badly made spreadsheet which features mutliples figures of text
(i.e. groups of numbers in one cell). I need to get each number seperated
out into it's own row.
Basically, I am looking for a function that works exactly like the "text to
columns" function / but is "text to rows".
Hope that makes sense.. thanks for your help!
S
Shannyduck
Sorry.. first time that I have had to this..
I have a badly made spreadsheet which features mutliples figures of text
(i.e. groups of numbers in one cell). I need to get each number seperated
out into it's own row.
Basically, I am looking for a function that works exactly like the "text to
columns" function / but is "text to rows".
Hope that makes sense.. thanks for your help!
I have a badly made spreadsheet which features mutliples figures of text
(i.e. groups of numbers in one cell). I need to get each number seperated
out into it's own row.
Basically, I am looking for a function that works exactly like the "text to
columns" function / but is "text to rows".
Hope that makes sense.. thanks for your help!
M
Morrigan
M
Morrigan
If you have a numer let's say 12345678 in A1
B1 = MID(A$1,ROW(),1) (Copy down)
or use the transpose method which David already mentioned.
Hope it helps
B1 = MID(A$1,ROW(),1) (Copy down)
or use the transpose method which David already mentioned.
Hope it helps