Thread: How make long string in a cell become text line by line in same cell?
View Single Post
  #4   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 because the result should be as below

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

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

Remove duplication and line by line in one in same cell





Reply With QuoteReply With Quote