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.