Distributing one column amongst multiple columns.

[ExcelNoob21222]

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]

One of my MOST used UDF is the following

Function SplitsItems(ByVal Invoer As String, ChrStr As String, Index As Integer) As String
  Dim myArray As Variant 'MyArray is a one-dimensional String Array
  myArray = Split(Invoer, ChrStr) ' string uitsplitsen
  If Index <= UBound(myArray) And Index >= LBound(myArray) Then ' What is the dimension of the Array. How many sub strings
    SplitsItems = myArray(Index)
  Else ' outside dimensions
    SplitsItems = "Wrong Index"
  End If
End Function

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.

[shg]

Select column A, then do Data > Text to Columns, tick Delimited, Next, in the Other box enter a comma, Finish