[Solved] Remove email link but leave formatting
[Solved] Remove email link but leave formatting
I am cleaning up a Calc spreadsheet that have two columns with email addresses. Some are marked as links; some are not. I want to remove the links from all the cells in the spreadsheet BUT I do not want to remove the other cell formatting (background color, borders, etc.) so setting the table cells to Default Formatting will not work for me. Any way to accomplish this (link removal without removing formatting)?
Last edited by Hagar Delest on Mon Apr 12, 2021 5:12 pm, edited 1 time in total.
Reason: tagged solved.
Reason: tagged solved.
--
Peace,
BobJ
Open Office 4.0.1, Windows 7
Peace,
BobJ
Open Office 4.0.1, Windows 7
- JohnSUN-Pensioner
- Volunteer
- Posts: 876
- Joined: Fri Jan 14, 2011 1:21 pm
- Location: Kyiv, Ukraine
Re: Remove email link but leave formatting
How about a Find And Replace with the regular expression Search for .* Replace with &?
I may not have a lot to give but what I got I'll give to you...
Apache OpenOffice 4.1.5, LibreOffice 6.4.4.2 (x64) on Windows 7
If you think that I did not answer your question, make allowances for my imperfect English
Apache OpenOffice 4.1.5, LibreOffice 6.4.4.2 (x64) on Windows 7
If you think that I did not answer your question, make allowances for my imperfect English
Re: Remove email link but leave formatting
Sounds good to me, I'll try tomorrow. Your answer is fine, but please confirm. Is it Find: .* (period, asterisk) Replace: & (ampersand)
--
Peace,
BobJ
Open Office 4.0.1, Windows 7
Peace,
BobJ
Open Office 4.0.1, Windows 7
- JohnSUN-Pensioner
- Volunteer
- Posts: 876
- Joined: Fri Jan 14, 2011 1:21 pm
- Location: Kyiv, Ukraine
Re: Remove email link but leave formatting
Yes, exactly. Don't forget More Options - Regular expressions ON and Search in - Formulas
I may not have a lot to give but what I got I'll give to you...
Apache OpenOffice 4.1.5, LibreOffice 6.4.4.2 (x64) on Windows 7
If you think that I did not answer your question, make allowances for my imperfect English
Apache OpenOffice 4.1.5, LibreOffice 6.4.4.2 (x64) on Windows 7
If you think that I did not answer your question, make allowances for my imperfect English
Re: Remove email link but leave formatting
AMAZING! Worked perfectly. And so easy. Thank you very much.
--
Peace,
BobJ
Open Office 4.0.1, Windows 7
Peace,
BobJ
Open Office 4.0.1, Windows 7