Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to rows?
I wanted to see if there was anything that could do text to rows instead of
text to columns. For example: 49159;49176;49179 so the data would look like: 49159 49176 49179 Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to rows?
The only thing I can think of is a 2 step process where you do your
text to columns delimiting on the semi-colon and then do a copy..paste- special Transpose to put them vertically. On Mar 19, 10:56 am, A.S. wrote: I wanted to see if there was anything that could do text to rows instead of text to columns. For example: 49159;49176;49179 so the data would look like: 49159 49176 49179 Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to rows?
You could do it in two steps. First do your normal text to columns. Then
follow this up with a copy and paste special/transpose. Will "A.S." wrote: I wanted to see if there was anything that could do text to rows instead of text to columns. For example: 49159;49176;49179 so the data would look like: 49159 49176 49179 Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to rows?
willwonka
Copy, select where you want the data placedpaste specialtranspose Mike Rogers "willwonka" wrote: The only thing I can think of is a 2 step process where you do your text to columns delimiting on the semi-colon and then do a copy..paste- special Transpose to put them vertically. On Mar 19, 10:56 am, A.S. wrote: I wanted to see if there was anything that could do text to rows instead of text to columns. For example: 49159;49176;49179 so the data would look like: 49159 49176 49179 Thanks. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to rows?
A.S.
With xl2k you can skip the first step and just do Transpose part. Mike Rogers "A.S." wrote: I wanted to see if there was anything that could do text to rows instead of text to columns. For example: 49159;49176;49179 so the data would look like: 49159 49176 49179 Thanks. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to rows?
A.S.
I stand corrected, I thought your data was in three columns. After cleaning my glasses...it became more clear!!! Mike Rogers "A.S." wrote: I wanted to see if there was anything that could do text to rows instead of text to columns. For example: 49159;49176;49179 so the data would look like: 49159 49176 49179 Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Only print rows with text | Excel Discussion (Misc queries) | |||
How do I insert 20 rows between each row of text? | Excel Discussion (Misc queries) | |||
Add a text to rows option | Excel Worksheet Functions | |||
Text to rows? | Excel Discussion (Misc queries) | |||
delete empty rows between rows with text | Excel Discussion (Misc queries) |