<

How to use Excel's Replace and Substitute functions

Posted on
3,009 Points
9 Views
Last Modified:
Published
Experience Level: Intermediate
10:54
Bob Flisser
Bob Flisser has authored many courses and books about Microsoft, Adobe and Apple products, and has been a computer trainer since the 1980s.
The Replace and Substitute functions will both swap out cell content, but they do it differently. The Substitute function will find content you search for, and the Replace function will count characters. Sometimes you want one method and sometimes you want the other. This video shows how they both work.
0
Author:Bob Flisser
0 Comments
This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA. In this part: Handling passwords.
For decades, the Visio org chart wizard has generated diagrams from data automatically. But all subsequent changes were manual and required recreating the diagram. The Visio Data Visualizer changes the game -- you can either change the data or the d…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month