Formatting

[Sifiso]

Dear all

please help.

I want the logic that will put the text (paragraph) in point form in the same cell.

Something Like: If this delimiter “|” is picked up then start below.

example

ID	Summary
0001	The bolt was 2mm out of spec. | obsolete drawing was issued. | remove obsolete drawings from the system.

Required Output

ID	Summary
0001	- The bolt was 2mm out of spec. - obsolete drawing was issued. - remove obsolete drawings from the system.

[flying008]

Hi, @Sifiso 

******

If can help you get your want, please mark it as s solution for more share.

[Sifiso]

Hi  flying008

can you attach the workflow?

[flying008 · Accepted solution]

Hi, @Sifiso 

The Formula:

Replace(Replace('-' + [Summary], "|", "|-"), "|", "
")