Hello, I am an expert in Excel training for beginners. Today, we will explore three examples of using the SUBSTITUTE function for multiple conditions. The SUBSTITUTE function is used in Excel to replace strings, making it useful for processing data with various conditions. Through examples, we will learn various ways to use the SUBSTITUTE function.
- Replace Specific String:The most basic use of the SUBSTITUTE function is replacing a specific string. For example, let’s say we want to replace the word “원” with “$” in the text in column A.
Original Data Data after Change A1: “1000원” =SUBSTITUTE(A1, “원”, “$”) - Replace Multiple Strings Simultaneously:You can easily replace multiple strings using the SUBSTITUTE function for multiple conditions. For instance, let’s assume we want to change “사과” to “apple” and “바나나” to “banana” in the text in column A.
Original Data Data after Change A1: “사과와 바나나” =SUBSTITUTE(SUBSTITUTE(A1, “사과”, “apple”), “바나나”, “banana”) - Various Replacement based on Conditions:Let’s also look at an example where different strings are replaced based on specific conditions. If we want to replace “A”, “B”, “C” with “1”, “2”, “3” respectively in the text in column A, we can apply the SUBSTITUTE function as follows:
Original Data Data after Change A1: “A B C” =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1, “A”, “1”), “B”, “2”), “C”, “3”)
Through these examples, we have briefly learned how to use the SUBSTITUTE function for multiple conditions. Leveraging the SUBSTITUTE function can make data processing more efficient and allow flexible replacement based on various conditions. Utilize the SUBSTITUTE function effectively in Excel to manipulate data as desired!