Go Back   MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Reply
 
Thread Tools Search this Thread Display Modes
Old Jan 18, 2013, 10:46 AM   #1
champ01
Guest
 
Excel: How to add a table into a single cell

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?
  0 Reply With Quote
Old Jan 18, 2013, 11:44 AM   #2
saotomefirst
macrumors regular
 
Join Date: Aug 2012
Location: Rio de Janeiro
Weeeeeeeeeeeeeeeeeeeeellllllllllll You are asking for something impossible... 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
saotomefirst is offline   0 Reply With Quote
Old Jan 18, 2013, 12:10 PM   #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.

Last edited by champ01; May 5, 2013 at 06:50 AM.
  0 Reply With Quote
Old Jan 18, 2013, 02:38 PM   #4
James Craner
macrumors 68000
 
James Craner's Avatar
 
Join Date: Sep 2002
Location: 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.

Click image for larger version

Name:	Screenshot_18_01_2013_19_33.png
Views:	231
Size:	38.4 KB
ID:	391043
__________________
Productivity Orchard Be more productive with your Mac
James Craner is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Table cell in Pages - how to put a diagonal line? Sir Loin Steak Mac Applications and Mac App Store 0 Nov 30, 2013 06:00 AM
Table View Cell Separator Lines Not Showing RagingGoat iPhone/iPad Programming 8 May 20, 2013 06:43 PM
can't configure table cell right straber iPhone/iPad Programming 9 Feb 12, 2013 09:59 PM
Resolved: Table View Cell Text Help iphonedude2008 iPhone/iPad Programming 3 Dec 5, 2012 06:48 PM
Resolved: allow dragging in table cell without overriding scrolling straber iPhone/iPad Programming 2 Jul 25, 2012 06:04 PM

Forum Jump

All times are GMT -5. The time now is 11:33 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC