Excel Macro Mastery
  • ubermenu logo50y
  • Member Area
      • Start here
          • How to use the Membership Area
          • The Blueprint for Learning Excel VBA
      • Downloads
          • 75+ Workbook Downloads(BETA)
          • Cheat Sheets(BETA)
      • Webinars
          • All Webinars

          • Most Popular
            • How to Design a VBA Application Like a Pro (Video)
            • 5 VBA Hacks Everyone Should know (Video)
            • How to use Class Modules in Excel VBA (Video)

          • Data Structures VBA
            • The Ultimate Guide to VBA Arrays (Video)
            • Excel VBA Collections – A Complete Guide (Video)
            • How to use the VBA Dictionary Like a Pro(Video)
          • Businesswoman pressing business type of modern buttons with virtHow to Copy Data Between ANY Two Sheets(Video)
  • VBA Articles
  • Courses
  • Webinars
  • My Account
      • Lost your Password?


    • Account Information
Excel VBA Split Function – A Complete Guide

Excel VBA Split Function – A Complete Guide

by Paul Kelly | May 7, 2019 | Strings and Text

Introduction The VBA Split Function is used is to split a string of text into an array. The text is split based on a given delimiter – e.g. a comma, space, colon etc. For example, imagine we have the following string: “Apple:Orange:Pear:Plum” You can...

You are not logged in

You are not currently logged in.








» Register
» Lost your Password?
  • Facebook
  • Twitter
  • Instagram
  • RSS

Designed by Elegant Themes | Powered by WordPress