Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can text in one cell be split into several cells? | Excel Discussion (Misc queries) | |||
Split date in cell into 2 separate cells | Excel Discussion (Misc queries) | |||
Split data from one cell to two separate cells | Excel Worksheet Functions | |||
separate text into different cells | Excel Worksheet Functions | |||
text cells end page how split to next. Text lost! | Excel Discussion (Misc queries) |