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!
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.
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
Thanks for great instruction. very good for my understanding. appreciate.
You are welcome!
thanks. very useful things. you British people very good teacher
Thank you! 😃
You're the man...Big help. Thanks!
You're very welcome 👍
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!
Thank you Wayne.
GOLD, thanks Allan
Thanks you Glenn.
AMAZING!!! Thanks a lot
Thank you, Marco.
Excellent video
Thank you
Thank you very much 😘😘😘
You're welcome 😊
Hi Alan, question: ¿Is it possible for multiple delimiters?
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.
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
excel guru
Thank you Yosep.
Super San
👍
rouw noumbah!
I need help, This type date to word want, 01-12-1986 to ZERO ONE - ONE TWO - ONE NINE EIGHT SIX, Pls help me