Splitting text string using formula...

[Dan1000]

I need to use a formula to split a text string using the commas as dividers with no spaces at either end of each string.

Maximum 4 commas to each string.

Is there a straight forward way of doing this rather than using the data to ccolumns excel command?

Regards

 

[Peter_SSs]

Here's the formula from post #15, dragged across. If that is not working for you, perhaps it might help if you posted a couple of your text strings.

Excel Workbook
	A	B	C	D	E	F	G
2	some text, separated, by various, amounts,of commas	some text	separated	by various	amounts	of commas
Separate text

 

[Peter_SSs]

I need to count the items before each comma and place them into separate - individual cells after the cell by dragging out.

A couple of samples of data and the expected results?

 

[Dan1000]

Thanks Peter.

I think its something to do with a switch in the options - manual / automatic calculations as the formula jumped into action when I switched it!?

 

[taurean]

Read this,
http://www.decisionmodels.com/calcsecretse.htm