Excel VBA – Split String into Cells

Associated Files Download Links

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: