The 14 Must-Know String Manipulation Functions In VBA

Рет қаралды 3,716

Күн бұрын

🔥 GET THIS + 350 OF MY BEST DONE-FOR-YOU TEMPLATES HERE ► rebrand.ly/350Wkbks_YTDesc
📚 GET A DISCOUNTED DEVELOPERS LIBRARY HERE ► rebrand.ly/UDVL_YTDesc
📣START LEARNING VBA HERE ► rebrand.ly/VBAEFFDan_YTDesc
🤖BRING AI INTO EXCEL WITH THIS INCREDIBLE ADD-IN ► rebrand.ly/AIToolpack_YTDesc
👉CREATE & SELL EXCEL BASED SOFTWARE IN MY MENTORSHIP PROGRAM ► rebrand.ly/MentorshipProgram_...
▶️ GET ACCESS TO OVER 100 UPDATED TRAININGS, WORKBOOKS & PDF CODEBOOKS: rebrand.ly/Patreon_YTDesc
👨‍💼BECOME AN EXPERT AT DASHBOARDS ► rebrand.ly/ExcelDashboard_YTDesc
🏝BECOME A SUCCESSFUL FREELANCER ► rebrand.ly/FreelancersAcademy...
⭐️JOIN KZfaq MEMBERS FOR UNRELEASED TRAININGS ► rebrand.ly/YTMembership_YTDesc
In this tutorial, I share the 14 best functions to use with manipulating strings in VBA. Along with a complete cheat sheet, this training will have you mastering strings in VBA in just a few minutes.
⬇DOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:
www.excelforfreelancers.com/S...
🤑 START EARNING BIG $$$ WITH MY AFFILIATE PROGRAM 👉 rebrand.ly/Affiliate_YTDesc
EXCEL COURSES:
►FREELANCER ACADEMY: rebrand.ly/FreelancersAcademy...
►MENTORSHIP PROGRAM: rebrand.ly/MentorshipProgram_...
►DASHBOARD MASTERCLASS: rebrand.ly/ExcelDashboard_YTDesc
►BEGINNERS VBA COURSE: rebrand.ly/VBAEFFDan_YTDesc
►WEB AUTOMATION COURSE WITH EXCEL VBA: rebrand.ly/WebAuto_YTDesc
EXCEL PRODUCTS:
►Turbocharge Your App Development: rebrand.ly/UDVL_YTDesc
►Get 350 Templates In 1 Zip File: rebrand.ly/350Wkbks_YTDesc
►Get ChatGPT Into Excel With This Addin: rebrand.ly/AIToolpack_YTDesc
►The Ultimate Excel Resource Guide: rebrand.ly/UERG_YTDesc
►Get Your Actual Employee Hourly Cost: rebrand.ly/LBC_YTDesc
►1000 Incredible Freelancing Resources: rebrand.ly/UFRG_YTDesc
🧐Find the Best Excel Products & Courses Here: rebrand.ly/ExcelProductsAndCo...
Timestamps:
0:00 - Introduction
2:51 - Len Function
3:44 - String Concatinate
4:57 - Left Function
5:45 - Right Function
6:48 - Mid Function
7:52 - String Compare
10:07 - Instr Function
12:39 - Replace Function
13:44 - Trim Function
14:32 - LTrim Function
15:32 - Case Conversion Example
16:32 - Process Text Example
JOIN OUR COMMUNITY:
►Facebook Group: rebrand.ly/EFF_Group
►Facebook Fan Page: rebrand.ly/EFF_FanPage
Follow me on my Social Media Accounts:
🤩TikTok: / excel4freelancers
🐦Twitter: / excel4freelance
🌏Website: www.ExcelForFreelancers.com
🔗LinkedIn: / excelforfreelancers
👤Facebook: / excelforfreelancers
📸 Instagram: / excelforfreelancers
🎥Rumble: rumble.com/c/ExcelForFreelancers
✉Telegram: t.me/ExcelForFreelancers
About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.
Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:
👉 / excelforfreelancers
New Training Video Uploaded Every Tuesday And Saturday!
Thank you very much for your continued support,
Randy Austin
#vba #excelvba #Vbaforbeginners #Excelforfreelancers #stringManipulation #stingsinvba #VBAString

Пікірлер: 27

@arlenegriffin4523 26 күн бұрын

Thanks for all your videos they are so informative and easy to understand. Bless you for sharing.

@ExcelForFreelancers 24 күн бұрын

For sure, you are very welcome Arlene. Thanks for your continued support over the years

@SyedMuzammilMahasanShahi 16 күн бұрын

Thank you much Randy for this amazing video.

@ExcelForFreelancers 16 күн бұрын

I am so glad you enjoyed it Syed. Thanks again

@kapibara2440 28 күн бұрын

Thank you for the video 😊 Nice stuff!

@ExcelForFreelancers 27 күн бұрын

For sure, you are very welcome and I am happy to help and share

@Info-God 28 күн бұрын

Very important chapter if one wants deep performance. Thank you!

@ExcelForFreelancers 28 күн бұрын

Thanks so much and I am glad you enjoy the training

@AliKhan-ik7wl 28 күн бұрын

As usual, very informative stuff. Thanks a lot for all your efforts and time. Stay blessed

@ExcelForFreelancers 28 күн бұрын

Thank you so very much, I really appreciate that

@czechyorker 28 күн бұрын

Thank you for sharing.

@ExcelForFreelancers 28 күн бұрын

For sure, you are very welcome and I am happy to help and share

@joemanflyer2001 27 күн бұрын

This will help in my other Excel projects !

@ExcelForFreelancers 26 күн бұрын

Oh great to hear that. Thank you Joe

@soiggeofficial 28 күн бұрын

Excel really needs dedicated RegEx functions. Could you make a RegEx VBA episode?

@Info-God 28 күн бұрын

Well. You have a powerfull programming language. Make your own RegEx. Be independent.

@Dexter101x 28 күн бұрын

It doesn't?

@ExcelForFreelancers 27 күн бұрын

Yes and thanks. I have it on my list of videos to create. I hope this helps and thanks so much.

@ExcelForFreelancers 27 күн бұрын

Thank you so very much, I really appreciate that

@danp6101 28 күн бұрын

Hi Randy. you forgot about the split function

@ExcelForFreelancers 27 күн бұрын

Thanks very much. I have used this a lot and included it in my arrays training here: kzfaq.info/get/bejne/f65-lKV7tcqylKM.html I hope this helps and thanks so much.

@nourreldeenmohamed367 27 күн бұрын

Mr randy What is the difference between step by step applications you do in this channel and the paid mentorship program ??? Is the tens of step by step applications you do in this channel substitute for the paid mentorship program ????

@ExcelForFreelancers 26 күн бұрын

Hi and thanks very much for your question. There is quite a large difference. In the KZfaq videos we often take shortcuts in order to get the templates done and we ONLY design the templates. In the Mentorship course I show you how to define, design, develop and deploy your Excel-based applications for passive income while I create a comprehensive accounting application in my Mentorship Program. This is a 132 hour in depth course. You can learn more about this incredible course here www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/