Description:
The REPLACE function uses to find the required value and replace with respective values.
Formula Syntax:
![](https://static.wixstatic.com/media/228a38_27e8ac907a1946dd822d65511894b861~mv2.png/v1/fill/w_422,h_365,al_c,q_85,enc_auto/228a38_27e8ac907a1946dd822d65511894b861~mv2.png)
Example:
![](https://static.wixstatic.com/media/228a38_7dd6cb232b9d427e9e75b60c8b7405c5~mv2.png/v1/fill/w_810,h_95,al_c,q_85,enc_auto/228a38_7dd6cb232b9d427e9e75b60c8b7405c5~mv2.png)
Important points:
When you use the REPLACE formula you need to know the start number and the number of characters of the required value.
Working file
Comments