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.

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.

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.

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.

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.

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.