Need Help? Chat with us

SUBSTITUTE() to replace characters

Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string.

Special Offer for First Time Users

If you are the first time user and want to learn Microsoft office skills, then you can avail this special offer discount on your email.

PIvot table Webinar payment Code




Learn 100+ Excel Tips & Tricks

Special Offer for First Time Users

If you are the first time user and want to learn Microsoft office skills, then you can avail this special offer discount on your email.

PIvot table Webinar payment Code

“To be an Excel Superstar”

Download ebook