+ Reply to Thread
Results 1 to 4 of 4

Pasting as Text while still keeping Table Format?

  1. #1
    Registered User
    Join Date
    06-09-2012
    Location
    illinois
    MS-Off Ver
    Excel 2007
    Posts
    3

    Pasting as Text while still keeping Table Format?

    Having some small issues that I am trying to correct while pasting some data from a web page. I have copied a table on a web page and what I want to do is keep the table format with the columns and rows in order but view the data exactly how it is seen on the web page. The problem is in some of the tables there are values like 2-05 which excel thinks is a date and changes it to Feb-5. There are also a handful of columns that have values like -14-15 and excel instead of posting that in the cell changes it to -29. If I paste as text I dont keep the table format. Is there any way to paste as text but keep the table format?

    I have tried to copy and paste the data in notepad first and the import but while I keep the formatting correct I lose out on keeping the columns in the data lined up since I have to use the space as the breaking point and there are words in one of the columns that all dont have the same number of spaces. Any help is greatly appreciated.

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Pasting as Text while still keeping Table Format?

    try formatting all the cells as text before pasting
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    06-09-2012
    Location
    illinois
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Pasting as Text while still keeping Table Format?

    Nope as soon as paste the cells lose the text format.

  4. #4
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Pasting as Text while still keeping Table Format?

    not when i try it, got a sample or the link you are copying from
    have you tried data tab/"get external data"/ from web?
    Last edited by martindwilson; 06-09-2012 at 07:26 PM.

+ 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