Paragraph2Line + Line2Paragraph

Converts paragraph to 1 line text or 1 line text to paragraph
Mainly used to convert multi-line text inside Excel cell into 1 line text or into full paragraph (with regular Enter)
Examples
Paragraph2Line(Cell1.value,,1) to convert excel cell into 1 line text with {{$C$}} as line separator
Line2Paragraph(Paragraph2Line(Cell1.value,,1)) to convert Excel cell with multi-line text into regular paragraph

CodeFunctionName What is this?

Public

Tested

Original Work

Access is limited.

Login here using your Linkedin account. to see or download code.

No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Mydevlib.com

Linkedin Login

ParagraphText, Optional Sepa = "{{$C$}}", Optional ExcelCell=0
or
LineText, Optional Sepa = "{{$C$}}", Optional ExcelCell=0

Views 3,289

Downloads 1,285

CodeID
DB ID

ANmarAmdeen
710
Attachments
Revisions

v1.0

Saturday
June
2
2018