How to use SPLIT Function in Excel VBA - Two Examples

[@freebird7556]

Thanks for great instruction. very good for my understanding. appreciate.

[@Computergaga]

You are welcome!

[@jay55patel]

thanks. very useful things. you British people very good teacher

[@Computergaga]

Thank you! 😃

[@gospelmoto2833]

You're the man...Big help. Thanks!

[@Computergaga]

You're very welcome 👍

[@wayneedmondson1065]

Hi Alan.. great video. As you mentioned, even though some worksheet functions and Power Query can do this kind of work, there is nothing like being in total control of the outcome with VBA. Your videos really help me develop my VBA brain, as well as learning how to analyze and tackle tricky challenges and problems via your examples. Thanks again and Thumbs up!

[@Computergaga]

Thank you Wayne.

[@glennlangford5897]

GOLD, thanks Allan

[@Computergaga]

Thanks you Glenn.

[@marcotulios8]

AMAZING!!! Thanks a lot

[@Computergaga]

Thank you, Marco.

[@MDYOUSUF-tl8sk]

Excellent video

[@Computergaga]

Thank you

[@learningNewIdea]

Thank you very much 😘😘😘

[@Computergaga]

You're welcome 😊

[@JavierRojas-pq2nl]

Hi Alan, question: ¿Is it possible for multiple delimiters?

[@Computergaga]

I do not believe that it can. Not that function in isolation anyhow. Of course, there are other ways and we can split a string multiple times by iterating/looping on it.

[@omerkhan9768]

I have text file C:\ in which A to Z alphabet are written horizontally like ABCDEF
and I wanna import these alphabets into excel sheet column A1 vertically on each new cell like
A
B
C
D
Is it possible using macros

[@yosepmardhiana2499]

excel guru

[@Computergaga]

Thank you Yosep.

[@sakthibalmohan]

Super San

[@Computergaga]

👍

[@Mindprinter]

rouw noumbah!

[@malarmathi2896]

I need help, This type date to word want, 01-12-1986 to ZERO ONE - ONE TWO - ONE NINE EIGHT SIX, Pls help me