Hi,



I need the help in the excel merge option.

I have the lines in the particular cell which is separated by line breaks.

For example,

Cell C8 have the 4 lines which needs to be merge with D8 which is also have 4 lines.

The think is needs to connect each line in C8 with D8 respectively. C8 First line should be connect with first line of D8.....

Please refer the screenshot.

Thanks
Ganesan. G

Sample attached here...

Attached Images

sample.PNG (16.0 KB, 32 views)

Please post a sample sheet with some data and expected results so one can work with it. It also makes the thread easier to read. Thx

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Please find the attached which i want to expect exactly...

Attached Images

sample.PNG (26.3 KB, 30 views)

Please post a sample sheet....NOT an image !!!

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Sample sheet attached here....

Attached Files

Sample.xlsx (9.5 KB, 12 views)

If it is possible in ms-word that is also fine. But the cell value remains same which means needs to be remained the multi lines.

Is this needed for any additional data?

Could you possibly share the solution?
It is a bit annoying having worked quite some time on the problem in an attempt to help you just to learn that the problem has been solved without learning anything as to what that solution was.

Hi Xor,

Sorry. I forgot to mentioned here what the reason to put solved this problem.

Actually i am just try other way in the ms word with the same requirement as per this thread and got the solution.

That's why i am just closed this thread and that solutions also enough for me.

Please check thread under the word named as "Need macro to merge columns" which is raised by me.

Anyway thanks for spending the time!!!

Thanks
Ganesan. G