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
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 Mydev.net
Linkedin Login
ParagraphText, Optional Sepa = "{{$C$}}", Optional ExcelCell=0
or
LineText, Optional Sepa = "{{$C$}}", Optional ExcelCell=0
or
LineText, Optional Sepa = "{{$C$}}", Optional ExcelCell=0
Views 3,289
Downloads 1,285
CodeID
DB ID
