background top icon
background center wave icon
background filled rhombus icon
background two lines icon
background stroke rhombus icon

Download "Excel VBA Introduction Part 53.1 - Working with Strings"

input logo icon
Table of contents
|

Table of contents

0:00
Excel VBA Introduction
1:28
The Sample Data
2:15
Basic String Variables
9:23
Strings and Nulls
16:36
Basic Concatenation
18:56
Concatenating Cell Values
22:53
Using the CStr Function
26:10
Concatenating a Tab Character
29:56
Concatenating a New Line Character
30:44
Eliminating the Trailing Character
35:23
Carriage Returns and Line Feeds
36:48
A Brief History of Control Characters
41:07
The Option Compare Statement
43:52
Comparing Strings in a Loop
46:50
Returning the First Letter of a String
48:23
Using Wildcard Characters
50:21
Matching a Whole Word
52:01
Creating a 'Does Not Contain' Pattern
52:55
Combining Criteria
58:16
Finding a Wildcard Character in a String
Video tags
|

Video tags

vba
visual basic for applications
string
strings
text
variable
cstr
convert
null
fixed length
concatenate
concatenation
ampersand
plus
tab
vbtab
new line
vbnewline
carriage return
vbcr
line feed
vblf
vbcrlf
chr(10)
chr(13)
case sensiive
option compare
binary
option compare text
wild card
wildcard
asterisk
question mark
pattern match
wise owl
You already have UDL Helper installed You can download video in 1 click!
Installed
for
Google Chrome

Description:

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-gould/introduction-to-excel-vba/paperback/product-23301058.html By Andrew Gould You can download the sample data used in this video here https://www.wiseowl.co.uk/vba-macros/videos/vba-functions/working-with-strings/ https://www.wiseowl.co.uk - This video explains the basics of working with text, or strings, in VBA. You'll learn about the String data type, how to use the $ type-declaration character and how to create variable and fixed-length strings. You'll see how to concatenate multiple values into a single string, including some string constants for special characters such as tab spaces and new lines - ever wondered why there are so many ways to create a new line in VBA? This video explains why! The final part of the video talks about comparing strings, including how to deal with case-sensitive comparisons and how to use wildcard characters to match paterns of text. 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

Preparing download options

popular icon
Popular
hd icon
HD video
audio icon
Only sound
total icon
All
* — If the video is playing in a new tab, go to it, then right-click on the video and select "Save video as..."
** — Link intended for online playback in specialized players

Questions about downloading video

mobile menu iconHow can I download "Excel VBA Introduction Part 53.1 - Working with Strings" video?mobile menu icon

  • http://unidownloader.com/ website is the best way to download a video or a separate audio track if you want to do without installing programs and extensions.

  • The UDL Helper extension is a convenient button that is seamlessly integrated into YouTube, Instagram and OK.ru sites for fast content download.

  • UDL Client program (for Windows) is the most powerful solution that supports more than 900 websites, social networks and video hosting sites, as well as any video quality that is available in the source.

  • UDL Lite is a really convenient way to access a website from your mobile device. With its help, you can easily download videos directly to your smartphone.

mobile menu iconWhich format of "Excel VBA Introduction Part 53.1 - Working with Strings" video should I choose?mobile menu icon

  • The best quality formats are FullHD (1080p), 2K (1440p), 4K (2160p) and 8K (4320p). The higher the resolution of your screen, the higher the video quality should be. However, there are other factors to consider: download speed, amount of free space, and device performance during playback.

mobile menu iconWhy does my computer freeze when loading a "Excel VBA Introduction Part 53.1 - Working with Strings" video?mobile menu icon

  • The browser/computer should not freeze completely! If this happens, please report it with a link to the video. Sometimes videos cannot be downloaded directly in a suitable format, so we have added the ability to convert the file to the desired format. In some cases, this process may actively use computer resources.

mobile menu iconHow can I download "Excel VBA Introduction Part 53.1 - Working with Strings" video to my phone?mobile menu icon

  • You can download a video to your smartphone using the website or the PWA application UDL Lite. It is also possible to send a download link via QR code using the UDL Helper extension.

mobile menu iconHow can I download an audio track (music) to MP3 "Excel VBA Introduction Part 53.1 - Working with Strings"?mobile menu icon

  • The most convenient way is to use the UDL Client program, which supports converting video to MP3 format. In some cases, MP3 can also be downloaded through the UDL Helper extension.

mobile menu iconHow can I save a frame from a video "Excel VBA Introduction Part 53.1 - Working with Strings"?mobile menu icon

  • This feature is available in the UDL Helper extension. Make sure that "Show the video snapshot button" is checked in the settings. A camera icon should appear in the lower right corner of the player to the left of the "Settings" icon. When you click on it, the current frame from the video will be saved to your computer in JPEG format.

mobile menu iconWhat's the price of all this stuff?mobile menu icon

  • It costs nothing. Our services are absolutely free for all users. There are no PRO subscriptions, no restrictions on the number or maximum length of downloaded videos.