How can I remove X number of characters from the front of a text field

[Kaelkitty1]

I have a list of complex text entries in a column in calc. They are of this form -

JFA2022/11/30 Coleus 'Rainbow" 2022 Six Pack #09 (added 2022/11/30 $0.50 Mitre 10: Nuriootpa) DEAD

JFA2023/11/08 Dianthus 2023 Potted Colour #01 “Purple” (added 2023/11/08 $2.95 Mitre 10: Nuriootpa) DEAD

JFA2023/11/08 Lobelia erinus [Trailing Lobelia] “Blue and White Mixed” (added 2023/11/08 $2.95 Mitre 10: Nuriootpa) DEAD

JFA2023/11/08 Lobularia maritima [Sweet Alyssum] Pot #1 (added 2023/11/08 $2.95 Mitre 10: Nuriootpa) DEAD

I want to convert them to this form (Without the code and date at the beginning of each line) so I can sort them alphabetically. The example above would change to -

Coleus 'Rainbow" 2022 Six Pack #09 (added 2022/11/30 $0.50 Mitre 10: Nuriootpa) DEAD

Dianthus 2023 Potted Colour #01 “Purple” (added 2023/11/08 $2.95 Mitre 10: Nuriootpa) DEAD

Lobelia erinus [Trailing Lobelia] “Blue and White Mixed” (added 2023/11/08 $2.95 Mitre 10: Nuriootpa) DEAD

Lobularia maritima [Sweet Alyssum] Pot #1 (added 2023/11/08 $2.95 Mitre 10: Nuriootpa) DEAD

I have looked on the LibreOffice 7.5 Help website (The LibreOffice Help Window) but I cannot find any clues how to do this. I have about 35,000 lines of text like this, so I cannot do it by hand. I would really appreciate any help.

Yours Sincerely,
Ms Jacq Felis.

[robleyd]

It seems your question can be summarised as

How do I remove text up to and including the first space in a text string.

If this is the case,

=MID(A1,SEARCH(" ";A1);999)

where A1 contains the text to be reduced. See attached sample file.
barossa.ods (20.5 KB)

[Kaelkitty1]

Yes, Thank you. I am very pleased.