Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the difference between SUBSTITUTE AND REPLACE functions in Ms Excel ?

Spreadsheets Microsoft Excel Microsoft Office MS Office tools
user-image
Question added by jhangeer bazmi , Computer Instructor and Operator , Imran Computer College Millat Chowk
Date Posted: 2017/03/15
Upvote (0) Views (9) Followers (1) Answers (1) Report Question
Write an Answer
Register now or log in to answer.
Firas Shahadi
by Firas Shahadi , Training And Development Director , Muhayal Assir National Hospital

Thank you for the Great Question.

 

to put it as simple as possible, like this

  1. if you know the text to replace use Substitute()
  2. if you know the place of the text to replace only use Replace()

make sense to you?

 

Regards

Write Your Answer
More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.

Get Help