Space between words

  • Thread starter Thread starter Fravo
  • Start date Start date
F

Fravo

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
 
Instead of a formula, you may want to select the column
data|text to columns
delimited by space
and finish up.
 
And data|text to columns will put the values in different columns. That does
what you describe--but not what you show in your example.
 
Hi Fravo,

Sounds like Edit>Replace might help here.

Select your data
Go to Edit>Replace
Find what: space
Replace with: Alt+010
Click Replace all
OK out

HTH
Martin
 
Back
Top