Thread: How make long string in a cell become text line by line in same cell?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
geniusideas geniusideas is offline
external usenet poster
  
Posts: 70
Default How make long string in a cell become text line by line in same cell?
Sorry Guys,

Not so accurate.

I need the the answer as below

Before
AAAAA (BBBB) (CCCC(DD)) | AAAAA (EEEE) (FFFFFF) | GGGGG (EEEE)
(HHHHHH)

After
AAAAA
(BBBB)
(CCCC(DD))
(EEEE)
(FFFFFF)
(GGGGG)
(HHHHHH)

Thanks anyway..
Reply With QuoteReply With Quote