Swap values in cells with excel REPLACE function
This beginners tutorial outlines how to use the REPLACE function in Microsoft Excel. This is an excel substitute function alternative which allows you to replace text in a specific position in your cell. Also learn how to combine with the FIND function (to replace text where you don't know the exact position). The video covers some examples of the replace function and looks at how to use the replace function with dates (using the TEXT function). You can also nest the excel replace function to change multiple values. Learn all the basics of the REPLACE function as you watch in our easy tutorial for beginners.
0:00 Introduction
0:58 Example 1 - correct incorrect reference
1:53 Example 2 - replace two characters
2:28 Example 3 - add an additional character using replace
3:13 Combining REPLACE with FIND function
5:27 Using REPLACE with dates
Learn Excel online for free: Our Excel for beginners tutorial will teach you all you need to know to take you from zero to Excel hero!
What Microsoft Excel tips and tricks do you want to learn? Let me know for future videos! I'll continue to develop tutorials covering Excel basics for beginners and will build up a catalogue of free Microsoft Excel course materials! :-)
Check out our playlists, such as our 'Introduction tutorials for beginners' playlist: • Excel for beginners - learn Excel wit...
Or check out our other videos, such as our video on how to use the FIND function:
• Excel for beginners: Combining the FI...
Or how to use the TEXT function:
• Excel for beginners: TEXT function an...
Learn how to use substitute as an alternative to replace: • How to use the excel substitute funct...
