SheetName = VBA.InputBox('Please Enter Worksheet Name')ĮndRow =. Private Const SourceColumn As String = 'A' Then, copy the following code and paste it into the code window.Next, in the pop-up code window, from the menu bar, click Insert -> Module.In the beginning, press Alt + F11 on your keyboard or go to the tab Developer -> Visual Basic to open Visual Basic Editor.You will learn how to split this string into multiple columns with VBA code in Excel. We added sub-strings such as, “ John Cena”, “ ”, “ Wrestler” and “ USA” together and put the comma (,) symbol between them to produce this long string. We have one long string, John Cena,Wrestler,USAin a worksheet named “ String” in our Excel workbook. Embed VBA to Split String into Multiple Columns in ExcelĬonsider the following dataset. Related Articles How to Split String into Multiple Columns with VBA in Excel: 2 Waysįollowing this section, you will learn how to split a string from one cell, multiple strings from multiple cells, and a specific range of strings into multiple columns with VBA in Excel.
