On UrbanPro

View My Profile       Proud to be a Teacher       Write a Review  

Tuesday, April 19, 2016

REPLACE Function in Excel

REPLACE Function is used when to replace text based on its location. or If you know the position of the text to be replaced, use the REPLACE function.

Syntex: =REPLACE (old_text, start_num, num_chars, new_text)

Parameter:

        old_text        - The text to replace.
        start_num     - The starting location in the text to search.
        num_chars    - The number of characters to replace.
        new_text      - The text to replace old_text with.


Example: