Hi,

I have a column that has strings with spaces. I need a formula that
when it finds a space, excel put it in a new column.
It looks like this:
Green Apple
White Car
Black Cloth

and it should be:
Green
Apple
White
Car
Black
Cloth

I need to substitute space for a line break.

I've already tried a lot of things, but with no sucess... i`m thinking
in export this into a txt file and make a perl script to do what i
need. but i think excel should do this and I don't know how.

Thx