To simplify text cell

[brunos31]

Hello everybody ,

I would to know if possible in VBA to copy/past the table and to simplify a cell and arrange this one.

So, I have a cell with some line, and would like to keep just the two firts line and arrange this one like:

1 - initial cell:
[A]
12/02: test
10/02: test

2 - result cell:
[A] - 12/02: test

Thank a lot in advance for your help,
Bruno

[Mumps1]

Try:

Please Login or Register  to view this content.

[brunos31]

Hi Mumps1,

It's very good, I understand now a script approach to slove this problem.

Thanks a lot for your assitance.
Have a nice day

[Mumps1]

My pleasure.

[brunos31]

I found a new problem ^^

For exemple, if the cell is empty or we have just one line, the code stop the process.
It's possible to ignore the empty line ?

[brunos31]

Solution:

Please Login or Register  to view this content.