Distributing one column amongst multiple columns.

**ExcelNoob21222** · 11-23-2008, 11:52 AM

Hi guys,

I'm an absolute noob. I am writing a master thesis, and I need to analyze some data. Unfortunately, the data from the server is all posted in column A. The only data is only separated by commas. I need to take the data thats in between the comma, and cut it in successive cells. For example the data is like this:
000987328, Kraft macaroni and cheese, 24 oz, 12 pk, $2.99 ea. , .....
I need it to look like this

the serial number stays in A, the label would be posted in collumn B, the package size in column C. This continues until all the data is separated and has its own column. This is critical to me because I am building a databank in access. Some of the information is irrelevant. I have thousands of entries. I can't manually delete each entry, that would take years. Please help.

A sample of the data, in its exact original format is attached. I eliminated the store name and only left a few items for confidentiality purposes.

Again, any assistance I would be greatful for.

**rwgrietveld** · 11-23-2008, 12:14 PM

One of my MOST used UDF is the following

Please Login or Register  to view this content.

It's a code I've picked up somewhere and adjusted it to my needs. It splitses a sentence and returns single words. Good luck.

The 'single' words are now in B1 and on. Just copy, Paste special values into A1.