Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBAonYIurK
VBA Working with Databases playlist https://youtube.com/playlist?list=PLNIs-AWhQzclbRVLCZlsFvpz6fz2nPGbt

Get files here https://www.wiseowl.co.uk/vba-macros/videos/vba-ado-net-recordsets/sql-excel-text-expressions/

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!

Learn how to write expressions to manipulate text in your SQL queries for Excel files. You'll learn how to concatenate text and other values and how to convert the data types of text and numbers using the CStr, CInt and Val functions. You'll see how to use the Replace and Trim functions to clean text values and how to calculate the length of a string with the Len function. You'll also learn how to find a character within a string using the InStr and InStrRev functions and use these in combination with the Left and Mid functions to split a string into multiple parts.

Chapters
00:00 Topic List
00:42 The Basic Setup
03:30 Concatenating Strings
06:42 Concatenating Text and Numbers
07:49 Concatenating Results of Functions
10:28 Converting Numbers to Text
11:58 Converting Text to Numbers
14:57 Filtering Numeric Values
16:54 Extracting Numbers from the Start of a String
18:08 The Replace Function
20:54 Changing the Example
22:26 The Len Function
23:54 Comparing String Lengths
26:07 The Trim Function
28:21 The Left Function
29:35 The InStr Function
31:13 Combining Left, InStr and Trim Functions
32:47 What if a String Cannot Be Found
33:33 Checking if a String Exists
35:31 The InStrRev Function
37:58 Getting Text from the End of a String
39:46 Extracting Text from the Middle of a String
44:30 What's Next?

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more