Hi Mariusz, thanks for the fast reply. I confirm it works to split the column on the first space delimter, use Text.Proper on that first column only, and then merge the two columns back together again. I was a little surprised this cant be done in one line, like when formatting to Text.Proper. However, its simple enough, which I like. In reality I have a column that is populated with values separated by a comma from a 'select multiple' question in a survey. Some rows have one value, some two, some three. Eg.
apples are red, bananas are yellow
oranges are orange, grapes are purple, mangoes are orange
blueberries are blue
I would like:
Apples are red, Bananas are yellow
Oranges are orange, Grapes are purple, Mangoes are orange