Text import, separate by first comma only

[risedu]

This is what I’m trying to paste

1 onions garlic
2 tomato ketchup
3 salt pepper

I would like LibreCalc to treat it like
±–±--------------+
| 1 | onions garlic |
| 2 | omato ketchup |
| 3 | salt pepper |
±–±--------------+

Instead of
±–±-------±--------+
| 1 | onions | garlic |
| 2 | tomato | ketchup |
| 3 | salt | pepper |
±–±-------±--------+

[Zizi64]

Here is a tip to split data by normal cell functions:

Special split data.ods (10.9 KB)

Finally you can copy/paste the result onto the target position without the formulas.

[karolus]

hallo
paste unchanged and use:

=TEXTBEFORE(A1;" ")
=TEXTAFTER(A1;" ")

[LeroyG]

If there are only numbers until 9:

• Ctrl+Shift+V
• Use text import dialog
  
  (o) Fixed width
  [x] Skip epmty cells
  Click on the ruler, once after the numbers, once before the text
  
  
  

[Lupp]

The solution given by @karolus should be preferable in most cases.
If additional data (rows) shall be appended frequently, a solution by user code may be wanted.
The attached example files exemplify this.
disask_136090_verySpecialSplit.ods (23.7 KB)
disask_136090_verySpecialSplit.csv.fake.ods (46 Bytes)
(The fake extension is needed because the upload filter doesn’t let pass .csv .)