Excel: How to add a table into a single cell

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

  1. champ01 Guest

    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. saotomefirst macrumors regular

    Aug 16, 2012
    Rio de Janeiro
    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")

    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. champ01 Guest

    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. James Craner macrumors 68000

    James Craner

    Sep 13, 2002
    Bristol, UK
    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.


Share This Page