text to rows?

A

A.S.

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.
 
W

willwonka

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.
 
R

roadkill

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
 
M

Mike Rogers

willwonka

Copy, select where you want the data placed>paste special>transpose

Mike Rogers
 
M

Mike Rogers

A.S.

With xl2k you can skip the first step and just do Transpose part.

Mike Rogers
 
M

Mike Rogers

A.S.

I stand corrected, I thought your data was in three columns. After cleaning
my glasses...it became more clear!!!

Mike Rogers
 
Top