Oh, there are the brackets. I was looking in the VBA code .

I didn't have a specific method in mind yet; before recommending anything I was going to ask to see what the data looked like after you just-plain-pasted it into Excel. Rereading now, I see what you meant by saying you want text-to-rows instead of text-to-columns; but at the time I didn't try too hard to figure it out, I thought I'd just wait and see.

Using Transpose will work for you one time, or five times. But how many times are you going to need it? You have to do a number of keystrokes and mouse clicks, guiding Excel through the text-to-columns method, and then again to transpose the results. If you need to do this just once, what your coworker suggested is good. But if you're going to have to do this many times—a few hundred times now, or twice each morning for weeks, or thrice a week for as long as you work there—then we may as well figure out something that involves even fewer keystrokes. What I would be working toward is a plain cut-and-paste operation, without text-to-columns, and running a VBA macro to transform the data once it's pasted in—or maybe even Excel knowing what to do as soon as you paste the data.

Or you can just let it go for now, and plan on contacting me again if you're doing it a lot and find you've started to get tired of it .