SUBSTITUTE

Modified on Wed, 29 May at 1:07 PM

Introduction

Returns the minute component of a specific time, in numeric format.


FORMULA

SUBSTITUTE(text, search_for, replace_with)

EXAMPLE FORMULASUBSTITUTE(company_col, "inc", "Inc.")
EXAMPLE INPUTGigasheet inc
EXAMPLE OUTPUTGigasheet Inc.


Sample Usage


Valid ExamplesInvalid Examples
SUBSTITUTE(Text Column, "Apple","apples")

SUBSTITUTE(Text Column, "123","apples") - 


Returns original column

SUBSTITUTE(Number as Text Data Type, "12", "13")SUBSTITUTE(Date, "2024-03-12 00:00:00.000", "2024-04-12 00:00:00.000")

SUBSTITUTE(Number Column, "12", "13")


Notes

  • Dates cannot be applied to NOT formula, 
  • This formula cannot be applied to number data type columns.


See Also


CONCAT


Still having issues? Contact us at support@gigasheet.com

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article