Split data with vba code after every comma.

**a1b2c3d4e5f6g7** · 04-23-2014, 10:52 AM

Is it possible to write a code, that after every comma the text is splitted to different collumns, in the same row of the first sentence of the alinea.

Split data doesn't do the trick

See attachment

**alansidman** · 04-23-2014, 11:09 AM

I am not quite sure I understand what you need. Can you provide an example of what your sample data should look like after "splitting?"

**Richard Buttrey** · 04-23-2014, 11:14 AM

Hi,

I'm not clear what you mean by 'in the same row of the first sentence of the alinea'. Nor indeed 'Split data'

Have you tried Data..Text to Columns, using just the comma as a delimiter?

Otherwise upload the workbook again and manually add examples of the results that you expect to see

**a1b2c3d4e5f6g7** · 04-23-2014, 02:56 PM

In the first sheet, two examples. In the second sheet the result i need. Instead of one column, it needs to be multiple columns (after every single comma). And every example in one row.

See attachment.

**a1b2c3d4e5f6g7** · 04-28-2014, 10:49 AM

Is it possible to write a code, that after every comma the text is splitted to different collumns, in the same row.

Split data doesn't do the trick

In the first sheet, two examples. In the second sheet the result i need. Instead of one column, it needs to be multiple columns (after every single comma). And every example in one row.

See attachment

**Richard Buttrey** · 04-28-2014, 11:50 AM

See if the attached helps. It doesn't need any code.

1. Copy the formulae in D1:I1 down your whole list.
2. Copy column D and use Paste Special Values to paste it somewhere else, typically another sheet.
3. Use TextToColumns on the copied list and specify the "|" character using the Delimited option. Be sure to deselect the comma delimiter.