Introduction
Returns the minute component of a specific time, in numeric format.
| FORMULA | SUBSTITUTE(text, search_for, replace_with) |
| EXAMPLE FORMULA | SUBSTITUTE(company_col, "inc", "Inc.") |
| EXAMPLE INPUT | Gigasheet inc |
| EXAMPLE OUTPUT | Gigasheet Inc. |
Sample Usage
| Valid Examples | Invalid 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
Feedback sent
We appreciate your effort and will try to fix the article