I have a list of names separated by semi-colons, which I can save in Word as plain text and then import into Excel as a "semi-colon delimited text file". My problem is that, in Excel, the data goes into a single *row* of cells whereas I want it to be in a single *column* and can find no way of selecting which way the delimited text file is imported.I'm sure VoG™ will know the answer. ;)
Copy the rowPaste Special and use "Transform"This turns rows into cols and vice versa.Hope this helps,Regards,Simsy
Many thanks, that's done the trick!
This thread is now locked and can not be replied to.
Galaxy Note 8 vs iPhone X
Awful clip art from 1994 is being tweeted every hour by a bot
iPhone X vs Samsung Galaxy Note 8
Les meilleurs navigateurs internet 2017
© Copyright 2017 IDG UK. All Rights Reserved.