Excel: How to add a table into a single cell

Discussion in 'Mac Applications and Mac App Store' started by champ01, Jan 18, 2013.

  1. Guest

    #1
    I need to import CSV files into the backend of my website.
    In Excel column D represents product specs (D2 is product specs of Product Y, D3 specs for product X etc etc.)
    All the specs I made are in Tables.

    How can I create a Table into a single cell?
     
  2. macrumors regular

    Joined:
    Aug 16, 2012
    Location:
    Rio de Janeiro
    #2
    Weeeeeeeeeeeeeeeeeeeeellllllllllll You are asking for something impossible... :p Cells fit into tables, not the opposite ;)

    However, a possible workaround would be to use the HIPERLINK function. It should give you the result you want, but I'm not sure if this is supported in recent Excel versions - I work with 2003 :(

    Here is an example:

    =HYPERLINK("[Y-spreadsheed.xls]sheet2!A1","Y item specs")

    where
    HYPERLINK -> receives text parameters (remember to use the "") ;)
    [Y-spreadsheed.xls] -> name of an external file to your desired spreadsheet
    sheet2 -> the name of the sheet you want to work with inside the file
    !A1 -> the cell where the cursor will be when it opens
    Y item specs -> what the user will read in the cell (make sure it makes sense XD)

    Hope this helps :D
     
  3. Guest

    #3
    I'm a real noob when it comes to Excel (i'm using Excel for Mac)

    Here is an example of what needs to be happening.
     
  4. macrumors 68000

    James Craner

    Joined:
    Sep 13, 2002
    Location:
    Bristol, UK
    #4
    In any version of Excel is it not possible to build a table into a single excel cell, normally when creating a csv file you match the fields that the application expects to the columns in an Excel spreadsheet. What you need to do is look at the output you need and then work backwards to build the worksheet. See the attached Excel screenshot with the associated CSV output. If this is not what you need, please can you post the an example of the CSV output then we may be able to help you better.

    Screenshot_18_01_2013_19_33.png
     

Share This Page