Hot Topics

Excel - Delimited Text File

  mgmcc 13:12 20 May 2010
Locked

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. ;)

  Simsy 13:34 20 May 2010

Copy the row
Paste Special and use "Transform"

This turns rows into cols and vice versa.

Hope this helps,

Regards,

Simsy

  mgmcc 13:58 20 May 2010

Many thanks, that's done the trick!

This thread is now locked and can not be replied to.

1x1 pixel
Elsewhere on IDG sites

Google Pixelbook Go review

Diversity Matters more than ever in illustration

Apple doubles price of MacBook Pro RAM upgrade

French Days 2020 : dates, sites participants & bons plans