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 , Freelance Graphics Designer
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 , Human Resources Director , SAUDI UNION

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