𝗪𝗜𝗟𝗗𝗘𝗦𝗧 𝗗𝗜𝗦𝗖𝗢𝗨𝗡𝗧 𝗢𝗙 𝗧𝗛𝗘 𝗬𝗘𝗔𝗥 - 𝟲𝟱% 𝗦𝗔𝗩𝗜𝗡𝗚𝗦 𝗙𝗢𝗥 𝗕𝗟𝗔𝗖𝗞 𝗙𝗥𝗜𝗗𝗔𝗬 https://www.excelforfreelancers.com/BFSale2024_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.
𝗗𝗢𝗪𝗡𝗟𝗢𝗔𝗗 𝗧𝗛𝗜𝗦 𝗪𝗘𝗘𝗞'𝗦 𝗪𝗢𝗥𝗞𝗕𝗢𝗢𝗞 𝗧𝗘𝗠𝗣𝗟𝗔𝗧𝗘 𝗛𝗘𝗥𝗘:
https://www.excelforfreelancers.com/StringManipulation
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
#vba #excelvba #Vbaforbeginners #Excelforfreelancers #stringManipulation #stingsinvba #VBAString