aaronnechama
New Member
- Joined
- Mar 11, 2009
- Messages
- 6
How do I split a series of cells based on commas? There is a series of data in 2 consecutive cells, with the data in each cell corresponding to the data in the adjacent cell. I need that each pair should be lined up in separate columns. Here is the example:
I need to match up the SKU with the corresponding Quantity in the adjacent column. Any ideas would be greatly appreciated.

I need to match up the SKU with the corresponding Quantity in the adjacent column. Any ideas would be greatly appreciated.