+ Reply to Thread
Results 1 to 4 of 4

copy table from website -heading ok but data misses col A

  1. #1
    Registered User
    Join Date
    12-01-2015
    Location
    ballarat
    MS-Off Ver
    2013
    Posts
    58

    copy table from website -heading ok but data misses col A

    Hello,
    I am trying to copy and paste a table from a website and it works with one exception.What happens is when I paste the data into my spreadsheet the heading is entered in the correct columns e.g. A-R,but the second row onwards that contains the data is offset and is entered from B-S.I wonder if anyone might be able to offer reasons or solutions please.
    The website is pw protected so I cannot make it available for inspection.

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily NL, sometimes UK
    MS-Off Ver
    2010
    Posts
    1,733

    Re: copy table from website -heading ok but data misses col A

    There's probably a blank character (mostly likely a space or a tab) at the start of each row, which Excel is interpreting as being a new column marker.
    You could confirm this by pasting the website data into Notepad first. Notepad won't make it into a table so it will probably look a bit of a mess, but you'll see if there is a space or tab at the start of each line.

    The solution depends on how often this needs to be done.
    If only occasionally, then it's probably easiest to fix manually. First go to A1 and insert a cell - choose the option to 'Shift cells right'. Then delete column A.
    If you need to do this often, then a macro is probably the best solution. The code below will do the same as above:
    Please Login or Register  to view this content.
    Hope that helps.
    Regards,
    Aardigspook

    My internet connection can be intermittent, so sometimes I may not reply quickly to questions. Sorry - it's not personal and I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  3. #3
    Registered User
    Join Date
    12-01-2015
    Location
    ballarat
    MS-Off Ver
    2013
    Posts
    58

    Re: copy table from website -heading ok but data misses col A

    Hello Aardigspook ,
    Many thanks for your prompt response.

  4. #4
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily NL, sometimes UK
    MS-Off Ver
    2010
    Posts
    1,733

    Re: copy table from website -heading ok but data misses col A

    You're welcome and thanks for the rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1