View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
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