+ Reply to Thread
Results 1 to 1 of 1

PSA: Using CODE tags to post sample data

  1. #1
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    PSA: Using CODE tags to post sample data

    I always see people attempting to copy/paste directly from Excel, or making an attempt to create a table using text and spaces. While it is understandable that sometimes uploading a spreadsheet isn't possible, there are ways to make it very easy to post examples other than screenshots (which are not useful in most situations, because the data can't be manipulated)

    So here is how to make it easier in those cases:

    Here is a screenshot of what my table looks like:

    thetable.PNG

    Simple table of cars.

    Here is what happens when I copy/paste it directly into Excelforum.

    Make Color Year Mileage
    Honda Red 2003 58,893
    Toyota Blue 2004 67,276
    Jeep Blue 2003 26,877
    Ford Blue 2002 49,992
    Ford Red 2005 21,935
    Toyota Blue 2000 92,505
    Ford Orange 2004 32,857
    Ford Blue 2001 79,588
    Pontiac Blue 2004 35,343
    Toyota Orange 2005 20,511
    Honda Blue 2005 87,036
    Honda Orange 2003 27,791

    Now, that isn't particularly useful, especially if there are spaces in the data.

    If you post it and wrap it in Code tags, it gets much easier to read:
    Please Login or Register  to view this content.
    This can be converted into a table in excel very easily by first pasting into Notepad, then copying from notepad and pasting into Excel. Text to columns will work in some cases too, if there are no spaces in the sets of data
    Last edited by JBeaucaire; 10-01-2014 at 07:54 PM.
    You should hit F5, because chances are I've edited this post at least 5 times.
    Example of Array Formulas
    Quote Originally Posted by Jacc View Post
    Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
    Click the * below on any post that helped you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How do I paste a table of sample data into a post
    By mmyers in forum The Water Cooler
    Replies: 9
    Last Post: 10-04-2012, 07:58 PM
  2. how to post sheet sample and code
    By Raygan in forum The Water Cooler
    Replies: 1
    Last Post: 12-10-2010, 03:03 AM
  3. [SOLVED] How to post sample data to this NG
    By M.Siler in forum Excel General
    Replies: 12
    Last Post: 06-27-2005, 07:05 PM
  4. [SOLVED] How to post sample data to this NG
    By M.Siler in forum Excel General
    Replies: 12
    Last Post: 06-27-2005, 07:05 PM

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