Excel VBA Introduction Part 58.11 - SQL for Excel Files - Text Expressions

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?

[datascientistoflife]

Great sir u r my first teacher who introduced me with vba...

[sebastian]

The way you explain technics you are using in the tutorial is outstanding! It’s explained in a very simple way with loads of examples easy to comprehend. Much obliged! 👏😀

[KhalilYasser]

Awesome and amazing. Thank you very much for these great efforts.

[FrancescoGrosso]

Amazing! Looks super interesting and fits the needs. I ought to watch all the videos! Before I do that, a quick question.
If you've got a query connection embedded onto the workbook (to DB), how can you refresh the results using VBA? I use ActiveWorkbook.RefreshAll, but I see it doesn't do the job properly..?!
PS: The links in the description don't work :/

[lcsillik]

Hi: How can I place a user defined function in the SOURCE so I do not use the LEFT function for instance but rather my own user defined function?

[frikduplessis]

Thank you again Andrew great tutorial, I'm so grateful that you share in so much detail with us how to become excel Ninjas 🥷Bless you