split text into separate cells
 

I have a list of book titles that came over all in one cell. I would like to
separate them into individual cells, one title per cell. They are separated
into lines using the "alt-enter" command to advance by one line when entering
text in a cell. If I can find a way for excel to recognize the "alt-enter" in
the text then i think i can do it with the find command. Any ideas?

Thanks in advance.

John T

split text into separate cells
 

try:

CHAR(10) for "alt_enter"

"jtaiariol" wrote:

I have a list of book titles that came over all in one cell. I would like to
separate them into individual cells, one title per cell. They are separated
into lines using the "alt-enter" command to advance by one line when entering
text in a cell. If I can find a way for excel to recognize the "alt-enter" in
the text then i think i can do it with the find command. Any ideas?

Thanks in advance.

John T

split text into separate cells
 

On 5ÔÂ7ÈÕ, ÏÂÎç10ʱ57·Ö, jtaiariol
wrote:
I have a list of book titles that came over all in one cell. I would like to
separate them into individual cells, one title per cell. They are separated
into lines using the "alt-enter" command to advance by one line when entering
text in a cell. If I can find a way for excel to recognize the "alt-enter" in
the text then i think i can do it with the find command. Any ideas?

Thanks in advance.

John T

try DataSplit

Regards,

Sebation.G

split text into separate cells
 

One way:

You could first use some code to replace the Alt+Enter characters with
commas.

Sub test()
Range("A1").Value = WorksheetFunction.Substitute(Range("A1").Value, Chr(10),
",")
End Sub

Then use Text to Columns from the Data menu.

HTH,
Paul


"jtaiariol" wrote in message
...
I have a list of book titles that came over all in one cell. I would like
to
separate them into individual cells, one title per cell. They are
separated
into lines using the "alt-enter" command to advance by one line when
entering
text in a cell. If I can find a way for excel to recognize the "alt-enter"
in
the text then i think i can do it with the find command. Any ideas?

Thanks in advance.

John T

split text into separate cells
 

You can use Text to Columns:
Pull-down:
Data Text to Columns..
check Delimited
clear all checkboxs except Other
click in the Other entry box and while holding down the ALT key type
010
--
Gary''s Student - gsnu200719


"jtaiariol" wrote:

I have a list of book titles that came over all in one cell. I would like to
separate them into individual cells, one title per cell. They are separated
into lines using the "alt-enter" command to advance by one line when entering
text in a cell. If I can find a way for excel to recognize the "alt-enter" in
the text then i think i can do it with the find command. Any ideas?

Thanks in advance.

John T

split text into separate cells
 

Very nice! I learn something new all the time.


"Gary''s Student" wrote in message
...
You can use Text to Columns:
Pull-down:
Data Text to Columns..
check Delimited
clear all checkboxs except Other
click in the Other entry box and while holding down the ALT key type
010
--
Gary''s Student - gsnu200719


"jtaiariol" wrote:

I have a list of book titles that came over all in one cell. I would like
to
separate them into individual cells, one title per cell. They are
separated
into lines using the "alt-enter" command to advance by one line when
entering
text in a cell. If I can find a way for excel to recognize the
"alt-enter" in
the text then i think i can do it with the find command. Any ideas?

Thanks in advance.

John T

split text into separate cells
 

And instead of using alt-0010, you could use ctrl-j

(even easier to describe and do!)

PCLIVE wrote:

Very nice! I learn something new all the time.

"Gary''s Student" wrote in message
...
You can use Text to Columns:
Pull-down:
Data Text to Columns..
check Delimited
clear all checkboxs except Other
click in the Other entry box and while holding down the ALT key type
010
--
Gary''s Student - gsnu200719


"jtaiariol" wrote:

I have a list of book titles that came over all in one cell. I would like
to
separate them into individual cells, one title per cell. They are
separated
into lines using the "alt-enter" command to advance by one line when
entering
text in a cell. If I can find a way for excel to recognize the
"alt-enter" in
the text then i think i can do it with the find command. Any ideas?

Thanks in advance.

John T


--

Dave Peterson

split text into separate cells
 

DataText to columnsLimited by other hit CTRL + j and finish.


Gord Dibben MS Excel MVP

On Mon, 7 May 2007 07:57:01 -0700, jtaiariol
wrote:

I have a list of book titles that came over all in one cell. I would like to
separate them into individual cells, one title per cell. They are separated
into lines using the "alt-enter" command to advance by one line when entering
text in a cell. If I can find a way for excel to recognize the "alt-enter" in
the text then i think i can do it with the find command. Any ideas?

Thanks in advance.

John T