Separating data into separate cells

[Brew]

How do you separate data into separate cells. Thanks

ex

A1=905
separate into
B1=9
C1=0
D1=5

 

[Greg Truby]

Aladin,

Thanks for letting me know that was intentional. It took some experimenting, but now I see your point. Brew - Aladin's is more robust. By taking out the "+1" and adjusting the reference inside of Column() it makes the formula susceptible to error if one inserts a column between EV and EW or if one selects the cells and drags them rightwards. Aladin's formula does not suffer the same weakness.

 

[Brew]

Thanks for the update.