- text—The text to replace.
- start_position—From the left, the character starting position (including spaces) that you want to replace
- num_chars—The number of characters to replace
- new_text—The replacement text
This example references the following sheet information:
|Clothing Item||Item Number||Sold Date||Ship Date|
|1||T-Shirt||C001||02/12/19 1:55 PM||02/15/19|
|2||Pants||C002||02/15/19 10:23 AM||03/20/19|
|3||Jacket||C003||02/20/19 2:45 PM||02/27/19|
Given the table above, here are some examples of using REPLACE in a sheet:
|=REPLACE([Item Number]1, 1, 1, [Clothing Item]1 + " ")||Replaces the first character of the string in row 1 of the Item Number column with the string in row 1 of the Clothing Item column; then, it adds a space||T-Shirt 001|
|=REPLACE([Item Number]2, 1, 2, "A1")||Replaces the first two characters in the string in row 2 of the Item Number column with the characters A1 from the formula||A102|
|=REPLACE([Sold Date]@row, 9, 9, " to " + [Ship Date]@row)||Replaces the time in row 3 of the Sold Date column with the Ship Date value in row 3; then, adds the string to (with spaces) between the dates||02/20/19 to 02/27/19|
Still need help?
Use the Smartsheet Formula Template to view examples and practice working with functions in real-time.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.