SUBSTITUTE

SUBSTITUTE helps you replace specified content in text within DBSheet formula fields. It provides the tools you need to apply text replacement in records, making your work more efficient and helping you accomplish tasks with ease. With SUBSTITUTE, you can create a formula field, enter the function in the formula editor, fill in parameters in the required format, replace all matching content or a specified occurrence, and combine the result with other functions such as IF or AND. Results are calculated immediately, refresh automatically when source data changes, and are also filled automatically after data import. Whether you're correcting text values, standardizing field content, troubleshooting parameter errors, or testing formulas on a small data set before wider use, SUBSTITUTE helps you stay productive and complete tasks efficiently across different devices and work environments. Choose the documentation below that best matches your needs to learn more.

1:53