Excel Guides

Replacing Links with Values in Excel

There are a few different ways to replace links with values in Excel. One way is to use the SUBSTITUTE function. This function takes three arguments: the text to search, the text to replace, and the text to replace with. So, for example, if you wanted to replace all instances of "www.google.com" with "Google", you would use the following formula:

=SUBSTITUTE(A1,"www.google.com","Google")

If you wanted to replace all instances of "http://www.google.com" with "Google", you would use the following formula:

=SUBSTITUTE(A1,"http://www.google.com","Google")

You can also use the REPLACE function to replace links with values in Excel. This function takes four arguments: the cell containing the text to search, the position of the character to start at, the number of characters to replace, and the replacement text. So, for example, if you wanted to replace "www.google.com" with "Google" in cell A1, you would use the following formula:

=REPLACE(A1,1,14,"Google")

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.