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

7 ways Alexa can make lockdown more bearable

Facebook Shops: How and when can I sell on Facebook and Instagram?

Different Think: Why Apple needs to stop being so cheap

Confidentialité : comment bloquer les pubs et empêcher les annonceurs de vous suivre ?