Remove formula but keep hyperlink

I've created a formula to remove text from the contents of a cell that includes a hyperlink.


Example:


A1 contents: Chelonoidis abingdonii (Abingdon island giant tortoise)


Formula in B1: =IFERROR(LEFT($A1,FIND(" (",$A1)−1),$A1)


B1 contents: Chelonoidis abingdonii


However, the formula is still present in B1. I've tried to remove the formula using: Copy->Paste, Copy->Paste and Match Style, and Copy->Paste Formula Results. In all cases, the function is removed, but the hyperlink is also lost.


I've searched the community and online and cannot find a solution. Has anyone else run into this problem and found a solution?


Thanks,

Mike

MacBook Pro 16″, macOS 26.0

Posted on Oct 19, 2025 3:07 PM

Reply
2 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Remove formula but keep hyperlink

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.