Solved: Entering several Replace formulas - Page 2

JenniferXP · 12-19-2024 05:54 AM

Hello, on the document you can see I've created a "theme" text field. My idea is to group all the utm-terms on the left that talk about the same subject together (example ota, OTA, OTA-com). I thought of using the REPLACE function, but is it possible to add several REPLACE functions to the field? I haven't succeeded. If you have any other ideas, I'd love to hear from you!
Thanks in advance

lauratilton

I don't use this kind of data so I'm not sure what you're replacing with what so I'll use a general example. Suppose I wanted to replace state names (in a field called State) with their capitals.

Think of it like this: Write the first REPLACE formula
REPLACE(State, "Massachusetts", "Boston")

If your state is California, nothing happens, it just returns California, so then you can nest the next formula like this...using the original formula instead of State in a new formula)

REPLACE(REPLACE(State, "Massachusetts", "Boston"), "California", "Sacramento")

and the next one like this

REPLACE(REPLACE(REPLACE(State, "Massachusetts", "Boston"), "California", "Sacramento"), "Texas", "Austin")

Note that in this example, if the State is "New York" then it will just return the original value of "New York". Hope that all makes sense!

View solution in original post