Excel VBA Introduction Part 53.4 - Replacing Strings

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

You can buy our Introduction to Excel VBA book here https://www.lulu.com/shop/andrew-goul...

By Andrew Gould

Download files here https://www.wiseowl.co.uk/videos/exce...

https://www.wiseowl.co.uk - In this video you'll learn how to use the Replace function to substitute characters within a string. As a practical example, we'll look at how to generate file names from cell contents and replace the illegal characters.

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio and more

• #education
• #vba
• #excel
• #replace
• #substitute
• #string
• #text
• #text_file
• #tab_delimited
• #case_sensitive
• #proper_case
• #wise_owl