Sorry, you're going to have to provide a sample for me to understand. To me, data in cells and table are the same thing, unless you're trying to do a text-to-columns split. I can't tell if you want to summarize the data, parse it, store it in memory, or just format it. An example workbook would make things more clear.