Split Cell content in multiple cells

Hallo All! I am very new to VBA Excel and i have a question. I have a sub routine which outputs some information in a cell that is separated by space. Something like that: "asda asda efrrwe werw 234 sfds". I just just to place each one of them in different cells! Could you help me out?! (i am not so into programming..)
Thanks!

Originally Posted by pomolo

Hallo All! I am very new to VBA Excel and i have a question. I have a sub routine which outputs some information in a cell that is separated by space. Something like that: "asda asda efrrwe werw 234 sfds". I just just to place each one of them in different cells! Could you help me out?! (i am not so into programming..)
Thanks!

You should used Split - VBA function


Function Split(Expression As String, [Delimiter], [Limit As Long = -1], [Compare As VbCompareMethod = vbBinaryCompare])

Member of VBA.Strings
Split a string into an array

Originally Posted by royUK

Can you show your existing code, remember to use Code Tags

This is basically an example code that i use together with imacro program. It reads a list of company names (companyname) and for every one of the list outputs a stock value.If you chose to output more than one value for every company name you get all infos in the same cell separated by space.
Could you help me out output those values, one in each cell?

Thanks Again for your quick reply!

pomolo

Please Login or Register  to view this content.