VBA HELP_Split text into cells

[Ravindra]

Hi All,

I want desired output in one sot. I need to split the text automatically into same row cells. Please see the enclosed file and help me in this concern.

 

[Asheesh]

Is it mandatory to use VBA, there are otherways of doing this ie, text to column or formulae..

If VBA is mandatory in this case, will provide the codes...

 

[Ravindra]

Is it mandatory to use VBA, there are otherways of doing this ie, text to column or formulae..

If VBA is mandatory in this case, will provide the codes...

yes VBA is mandatory, no other choice. Please help me.

 

[Hui]

What are the rules when there is only 1, 2 or 3 words in the Name column
ie: Which name is which

 

[Deepak]

@ Ravindra

If u are looking for text splitting then check this....

http://chandoo.org/wp/2011/08/23/split-text-on-new-line-macro/

http://chandoo.org/forum/threads/split-string-in-adjacent-cells.23729

 

[shrivallabha]

Besides you will need rules for dealing with Names having less than 4 words as to the field in which they should be placed.
e.g. Ali - Can be placed in any of the 4 fields...