Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,339
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,311
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,058
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,311
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can text in one cell be split into several cells? Mistie Excel Discussion (Misc queries) 9 September 10th 06 03:53 AM
Split date in cell into 2 separate cells Jambruins Excel Discussion (Misc queries) 1 August 9th 06 06:16 PM
Split data from one cell to two separate cells Michele Excel Worksheet Functions 2 October 25th 05 09:27 PM
separate text into different cells yamareezy Excel Worksheet Functions 2 September 8th 05 08:28 PM
text cells end page how split to next. Text lost! Elaine Excel Discussion (Misc queries) 1 August 28th 05 05:48 PM


All times are GMT +1. The time now is 10:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"