Ten commonly used string functions in Microsoft Excel 365 for Windows
Автор: Siddharth Rout
Загружено: 2022-05-12
Просмотров: 412
Описание:
When you are working in VBA, at some point of time or the other you will have to work with strings. You will have to manipulate the string to get the desired result. In this video, I bring to you 10 commonly used string functions in VBA. These string functions will allow you to extract substrings from strings, convert the case of a text or string, remove spaces from strings, and so many other things.
Watch the video to understand how to manipulate the strings using 10 commonly used string functions in VBA.
----
00:00 Intro
00:56 Len() Function
04:11 Left() Function
05:40 Right() Function
06:21 Mid() Function
09:54 Trim(), RTrim() and LTrim() Functions
12:42 LCase() Function
13:42 UCase() Function
14:00 StrConv() Function
16:05 Instr() Function
21:36 Format() Function
23:00 Named Format Vs User Defined Format
32:54 Outro
----
Equipment/Software used for recording and editing this video
Camera: https://amzn.to/3IJqos7
Microphone: https://amzn.to/3MhA5Ac
Lights: https://amzn.to/3ptjxLV
Camtesia: https://techsmith.z6rjha.net/SidRecom...
Disclaimer: The above are affiliate links. At no additional cost to you, we will receive a small commission if you make a purchase using the above links. This helps support the channel. Thank you in advance for your support!
Connect with me on social:
LinkedIn: / siddharthrout
Facebook: / msexcelvba
Instagram: / altf11ninja
X: https://x.com/AltF11Ninja
Stackoverflow: https://stackoverflow.com/users/11405...
#ExcelVBA #ExcelMacro #VBAExcel #MSExcel #Excel
Повторяем попытку...

Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: