Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How make long string in a cell become text line by line in same cell?
Hi, All
I really need desperately in VBA code for my new project! I have long text string in single cell which separated by bracket as below: AAAAA (BBBB) (CCCC(DD)) | AAAAA (EEEE) (FFFFFF) | GGGGG (EEEE) (HHHHHH) The above text is one line and sometime up to 300 characters. What I need to do is to split the above text line by line and remove duplication as below but still in the same cell: AAAAA (BBBB) (CCCC(DD) (EEEE) (FFFFFF) (GGGGG) (HHHHHH) The sequence must be kept and as you can see the duplication already remove for AAAAA and (EEEE). Hopefully anyone here can help.Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ? | Excel Programming | |||
Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ? | Excel Worksheet Functions | |||
Excel - How do I fit 2 lines of text in one cell, vs a long line? | Excel Discussion (Misc queries) | |||
how do I make more then one line of pasted text not move to one cell? | New Users to Excel | |||
A 2 line text showing up in the Cell in Excel prints in 1 line | Excel Discussion (Misc queries) |