[Solved] Remove email link but leave formatting

Discuss the spreadsheet application
Post Reply
bobjbkln
Posts: 4
Joined: Sat Dec 28, 2013 9:56 pm

[Solved] Remove email link but leave formatting

Post by bobjbkln »

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.
--
Peace,
BobJ
Open Office 4.0.1, Windows 7
User avatar
JohnSUN-Pensioner
Volunteer
Posts: 876
Joined: Fri Jan 14, 2011 1:21 pm
Location: Kyiv, Ukraine

Re: Remove email link but leave formatting

Post by JohnSUN-Pensioner »

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
bobjbkln
Posts: 4
Joined: Sat Dec 28, 2013 9:56 pm

Re: Remove email link but leave formatting

Post by bobjbkln »

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
User avatar
JohnSUN-Pensioner
Volunteer
Posts: 876
Joined: Fri Jan 14, 2011 1:21 pm
Location: Kyiv, Ukraine

Re: Remove email link but leave formatting

Post by JohnSUN-Pensioner »

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
bobjbkln
Posts: 4
Joined: Sat Dec 28, 2013 9:56 pm

Re: Remove email link but leave formatting

Post by bobjbkln »

AMAZING! Worked perfectly. And so easy. Thank you very much.
--
Peace,
BobJ
Open Office 4.0.1, Windows 7
Post Reply