In this video we're going to learn how to split one column into two by using the Split function in Microsoft Access and VBA. As long as there is a definite pattern in the source column, it is easy to use the split pattern to separate elements into their own columns. This can be used with any delimiters; for example , ~ | or even multi-character delimiters like ", " or a word with spaces " and " etc. Because you're using a custom function, it gives powerful results because you can add extensive programming to handle exceptions, muddy data, complex transformations, and more. I use this one all the time in transformations. It can also be used in vb.Net for batch transformations etc. Use it to just split one column into two, or walk through a 50 column CSV file and split up data row by row for intricate transformations. The possibilities are endless. Related Videos: How to Use Union Queries in MS Access https://www.youtube.com/watch?v=LHWYq5NgxgI How to Split One Column Into Two in Access Using the Split Function You are watching this video now! How to Query the Last Row in a Series in Microsoft Access https://www.youtube.com/watch?v=5cnwHyn4dnI How to Format Dates in MS Access Queries, Forms, and VBA Code https://www.youtube.com/watch?v=TaohJxP0-MI How to Use Nz in Microsoft Access to Handle Null and Empty Values https://www.youtube.com/watch?v=CR3FmVoRFys How to Use Crosstab Queries in MS Access https://www.youtube.com/watch?v=XRLS-XJ79ns How to Use Functions in MS Access Queries https://www.youtube.com/watch?v=i9W1Abkg5cs Follow us on social media: https://www.facebook.com/mackenziedataanalytics/ https://twitter.com/seamacke https://www.instagram.com/seamacke/ https://www.reddit.com/user/seamacke https://www.linkedin.com/in/psmackenzie/ Get Microsoft Office including Access: https://click.linksynergy.com/fs-bin/click?id=BdGJecFFM8A&offerid=1160033.10004289&type=3&subid=0 Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenziedataengineering how to split one column into two in access using the split function split one column into two in access access vba split function vba split function vba split function example how to split a delimited string in access data analytics data analysis data transformation data science microsoft access split function visual basic for applications sean mackenzie