Find and Replace

1

Hi. I am looking to replicate the Find and Replace functionality in Excel. For instance, I want to replace "ftp:" with "http:" and replace "/800/" with "/hires/". How can this be accomplished?
image

2

You can use the replace() function twice.

3

That worked. Thanks.