Results 1 to 3 of 3

Thread: Colums (97)

  1. #1
    Star Lounger
    Join Date
    Oct 2003
    Posts
    50
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Colums (97)

    Hi I have a pdf file which has 17 pages. Im currently pasting a particular colum from the pdf pages using the ctrl select key. When i paste it into excel the data just goes into one cell i use text to colum feature which works fine but it separtes the data horizontally using many colums id like the data presented vertically in one colum. Has anyone any ideas?
    Thanks for the help in advance,
    Rob.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Colums (97)

    Copy, paste-special - transpose

    Steve

  3. #3
    Star Lounger
    Join Date
    Oct 2003
    Posts
    50
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Colums (97)

    Cheers Steve that works fine now,
    Rob.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •