EXCEL Remove hyperlink function

The EXCEL Remove hyperlink function removes the hyperlink from a cell.

Help CentreBuilding Processes

This article describes the RPA Excel functionality to remove a hyperlink from a cell.

For a full list of available functions, please read EXCEL functions.


Description

The EXCEL Remove hyperlink function removes the hyperlink from a cell while keeping the cell's display text intact. The text remains in the cell but is no longer clickable.


Setting it up

To use the EXCEL Remove hyperlink function, follow these instructions:

{{popups:rpas/add:action=excel-remove-hyperlink}}

Once on a process map:

  1. Navigate to the process where you would like to add the EXCEL Remove hyperlink function
  2. Click on the green button's drop-down (right side of the green button labelled "Process")
  3. On the menu that appears, click on the "+ Activity" item
  4. From here you can select the EXCEL Remove hyperlink option
  5. Click "Add" once you are done

Input parameters

ParameterRequiredTypeDefaultDescription
File pathYesTextFull path to the Excel file.
SheetYesTextName of the sheet.
CellYesTextCell address (e.g. A1).

Output variables

This action does not produce any output variables.


Errors

ErrorDescription
File not openThe Excel file must be open.
Sheet not foundThe specified sheet does not exist.
Invalid cellThe cell reference is not valid.

Tips

  • The display text in the cell is preserved – only the link is removed.
  • Use Clear cell if you want to remove both the link and the text.

Related functions

See it working on your own data

Everything documented here ships with the platform – try the document tools free, or go live in 7 days.