Hi Ginu,
You'd need a formula for each cell.
Formula for Cell 1 would be:
Split({string field}, ' ')[1]
Formula for Cell would be:
Split({string field}, ' ')[2]
And so on...
Place each formula beside each other so that it generates a new cell when exported to Excel.
-Abhilash
What is the formula you used?
Does it display blank?
-Abhilash
I have used the formulae1
split(totext({IC3_ASSESSMENT.ASSESSMENT_END_DATE},","))[1].
It was the same way dispalyed all together in one cell.
But if we have so many records(concatenated data) do we need to write that much formulaes for sitting data in separate cell.Dont we have any dynamic ways to handle it?
Add comment