Return to VBA Code Examples

Excel VBA – Split String into Cells

This tutorial will demonstrate how to split strings into cells.

Split String into Cells

In VBA, we can use the Split Function to split a string of text into an Array.

Note: We wrote an entire mega-guide to using the Split Function in VBA. We highly recommend that you check it out.

Then we can loop through the array, outputting the split text into Excel cells:

Alternatively, we can use the Transpose Function to output the array into a worksheet: