Working with Strings || Excel VBA Master Class || 3.4d
Автор: Skills and Automation
Загружено: 2024-09-14
Просмотров: 512
Strings are fun to manipulate and VBA provides us with many tools such as Functions and Operators to slice and dice and shape text data any way we want.
In this long lesson, we will cover a lot of examples that we will help us:
Insert Characters using Chr()
Determine Length of a string using Len()
Check whether a string is blank or not
Join strings using & and + operators
Extract parts of strings using Left(), Right(), Mid()
Search within strings using InStr(), InStrRev()
Split a string into a set of substrings using Split()
etc.
#vba #excel
Follow the rest of the series, in the below playlist:
• VBA MasterClass
Code snippets can be found here:
https://skillsandautomation.com/maste...
00:00 Intro
00:43 String Characters
05:57 String Types
07:42 Empty String
10:33 Concatenation
11:27 String Manipulation
22:12 String Comparison
27:24 Formatting String
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
