answersLogoWhite

0


Best Answer

The Replace function replaces part of a text string, based on the number of characters you specify, with a different text string. The Substitute function substitutes newtext for old text in a text string. You use Substitute when you want to replace specific text in a text string and you use Replace when you want to replace any text that occurs in a specific location in a text string.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What are differences between replace and substitute Microsoft Excel functions?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Differences between Microsoft Office 2010 and Microsoft Office 2007?

there are too small differences if you are using regularly for home use


What are the differences between Microsoft Access and database?

None. Microsoft Access is a database application.


What are the differences between Microsoft Excel and XMl?

the inner format.


Are there differences between the Microsoft and Apple organizational cultures and what are they?

There are definitely differences in the companies. They are in constant competition with each other. One huge difference between the Microsoft and Apple organization cultures is secrecy. Apple has rumors fly about and Microsoft leaks previews of their stuff.


What are the differences between Microsoft Word 2003 and Microsoft Word 2008?

Office 2003 works under windows, the 2008 under mac.


What are the differences between a Microsoft Excel spreadsheet and a Google spreadsheet?

different brands and different navigation


Are there any differences between Microsoft PowerPoint 2003 and Microsoft PowerPoint 2007?

Yes, PowerPoint 2007 has a compleatly different layout. You can download a trial from the Microsoft office online website.


What are the differences between Windows Server 2003 and Microsoft Office 2003?

Windows Server 2003 is an operating system. Microsoft Office 2003 is an office suite.


What the differences between Microsoft Office 2007 and Microsoft Office 2010?

Well Microsoft office 2007 is very good but Microsoft office 2010 is better, the reason for this is because the actually documents you do on Microsoft like word and spreadsheets are a lot clearer


What similarities and differences do you see between the function and linear equations?

Linear equations are a tiny subset of functions. Linear equations are simple, continuous functions.


What are the differences between window for writer and window for microsoft word?

If you are asking what the differences are between Libre Office Writer and Microsoft Word, then the difference primarily is in the way the user interfaces looks. However, they do basically the same things and Libre Office Writer is compatible with Microsoft Word & vice versa. The added bonus to using Libre Office Writer is that it is free.


What do reviews say regarding the difference between Microsoft vs Apple?

The differences in their tablets are that the hardware surface of the Microsoft table is much more smaller than the Ipad. The tablet is also sleek and has shine.