Ask Your Question

Find text after a specific character in Calc

asked 2019-02-16 23:45:58 +0200

Dave Quail gravatar image

updated 2019-02-16 23:48:23 +0200

Hi there, I am new here, and also new to Libreoffice. I have used Excel for many years, but have moved to Libreoffice recently. I hope to find an answer to a problem i have extracting text in a cell, following a specific character. "@" This character is part of a list of email addresses i am working on, so will not always be in a static position. The Excel equivalent formula is: =MID(D3,SEARCH(@,D3)+1,255), where D3 is the cell reference containing the text. This formula returns an error in Calc, despite me replacing commas with semicolons and placing @ within quotes "@". e.g., or "@" is not at a fixed position in the text string. I would like to extract only. Thank you.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-02-17 00:17:50 +0200

robleyd gravatar image

This works for me in


Sample file attached; C:\fakepath\midtest.ods

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.

edit flag offensive delete link more


Thanks robleyd, the semi-colons and quotation marks were the difference. We live and learn!

Dave Quail gravatar imageDave Quail ( 2019-02-17 09:49:19 +0200 )edit

Thanks guys. This was a great question and a great answer. Had an issue and needed to get through a few hundred records to sort ( addresses, not emails ) and this worked perfectly. I was able to sort out and re-save them all in just a few minutes and with only two formulae.

Amalit gravatar imageAmalit ( 2020-02-28 03:00:05 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-02-16 23:45:58 +0200

Seen: 837 times

Last updated: Feb 17 '19