Ten commonly used string functions in Microsoft Excel 365 for Windows

Описание: 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