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.



Fravo wrote:

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

--

Dave Peterson

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.

Fravo wrote:

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

--

Dave Peterson

Hi Fravo,

Sounds like EditReplace might help here.

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

HTH
Martin



"Fravo" wrote in message
ps.com...
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