How to perform function Replace if condition is met?
Page 1 / 1
Are you asking how to nest formula functions inside each other?
IF(
condition,
SUBSTITUTE( string, old_text, new_text)
)
Can you give an example of what you want?
Are you asking how to nest formula functions inside each other?
IF(
condition,
SUBSTITUTE( string, old_text, new_text)
)
Can you give an example of what you want?
If I use FILTER, it is not possible to add replacement. So, replacement is not like Excel. Should we use code inside another filed not FILTER?
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.