REPLACE and SUBSTITUTE Formula Usage
REPLACE and SUBSTITUTE Formula Usage is preferred in text editing. Additionally this Excel file enables specific characters within a cell to be replac
Excel Source: Replace and Substitute Formula Usage
REPLACE and SUBSTITUTE Formula Usage is preferred in text editing. Additionally this Excel file enables specific characters within a cell to be replaced with different values. Because the functions offer position-based and pattern-based approaches, flexibility is ensured. Thus data editing operations are completed in a short time. Therefore the file is used by those cleaning data.
Hope it is useful.