Please help as soon as possible...

Please explain what you want. Quickly now.

--
Don Guillett
SalesAid Software

"Shannyduck" wrote in message
...
Please help as soon as possible...

We cannot help you unless you provide a decent explanation of what you are
trying to accomplish!!

"Shannyduck" wrote:

Please help as soon as possible...

So confusing what you actually want done. Care to offer a little bit more to
go on?

--
Regards,
Dave


"Shannyduck" wrote:

Please help as soon as possible...

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!

"Don Guillett" wrote:

Please explain what you want. Quickly now.

--
Don Guillett
SalesAid Software

"Shannyduck" wrote in message
...
Please help as soon as possible...

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
--
Regards,
Dave


"Shannyduck" wrote:

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!

"Don Guillett" wrote:

Please explain what you want. Quickly now.

--
Don Guillett
SalesAid Software

"Shannyduck" wrote in message
...
Please help as soon as possible...

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!


"Duke Carey" wrote:

We cannot help you unless you provide a decent explanation of what you are
trying to accomplish!!

"Shannyduck" wrote:

Please help as soon as possible...

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!


"David Billigmeier" wrote:

So confusing what you actually want done. Care to offer a little bit more to
go on?

--
Regards,
Dave


"Shannyduck" wrote:

Please help as soon as possible...

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!


"Duke Carey" wrote:

We cannot help you unless you provide a decent explanation of what you are
trying to accomplish!!

"Shannyduck" wrote:

Please help as soon as possible...

What do you mean convert text to rows?


Shannyduck Wrote:
Please help as soon as possible...


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=401500

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.


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=401500