Hi,
I'm trying to figure out how to split this data in the same cell - 543<br /> 3573<br /> skm
so it shows in the cell as:
543
3573
skm
any suggestions?
@berty have a look at the attached workflow.
Your delimiter is the <br /> so we can use the Text to Columns to split by rows or columns. In your case, splitting to rows will work.
We are then filtering only the data you need (non empty value).
I don't need it split to rows, i need it split to new line in cell like so:
@berty I have amended your workflow to add the Summarize. This allows us to Concatenate the data with a newline (\n) delimiter.
Hi @berty
You can use a formula something like this
Replace([Field1], "<br /> ", "
")
where you are replacing <br /> with line break
Workflow
Hope this helps 🙂