G
Guest
Please help as soon as possible...
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
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.
G
Guest
We cannot help you unless you provide a decent explanation of what you are
trying to accomplish!!
trying to accomplish!!
G
Guest
So confusing what you actually want done. Care to offer a little bit more to
go on?
go on?
G
Guest
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!
G
Guest
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
G
Guest
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!
G
Guest
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!
G
Guest
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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.