Use the REPLACE and SUBSTITUTE Functions

If you want to find some values and replace it with other values there are two functions that can help you do this. Similar to the find and replace feature in Excel this uses functions to accomplish it. Learn how to use the REPLACE and SUBSTITUTE functions by checking out the video.