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?
You can use the replace() function twice.
That worked. Thanks.