Paste special with custom delimiter [closed]

asked 2013-06-03 12:21:23 +0200

Paijo gravatar image

updated 2013-06-03 12:22:22 +0200

I want to paste something into Calc with some delimiter, as: 1. 0x0D0A09 as next field/colum (09 is equal to tab, but lead with cariage return) 2. 0x0D0A as new line

How do I do that?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-04 19:09:25.853055


I haven't exactly understand what you mean, because, well, Calc already parses text when pasted. And there's huge dialogue which allows to set up parse options. If you want some text with CRLFs into single Calc cell, you can enter edit mode (F2 or double-click) and paste it. If you want paste several cells with multiline text, better prepare some CSV or HTML instead. (if CSV, see there: )

LogicDaemon gravatar imageLogicDaemon ( 2015-01-16 22:14:12 +0200 )edit