Merge cells of emails into one cell - possible?

[Jyggalag]

Hi all,

I have the following setup (albeit in a much larger setting with multiple lines of emails):

I want to merge my emails in A121 and A122 into one cell, like I have done above in A120.

Is this possible? In reality, I need to do this for about 50-100 rows of emails from column B-T approximately.

Would truly appreciate some help here - thank you all!

Kind regards,
Jyggalag

 

[Joe4]

I think you should be able to just use the TEXTJOIN function.
See here: MS Excel: How to use the TEXTJOIN Function (WS)

 

[Jyggalag]

I think you should be able to just use the TEXTJOIN function.
See here: MS Excel: How to use the TEXTJOIN Function (WS)

Brilliant!!!
Thank you so much Joe! Much love to you

This is an example of how it works for anybody wondering:

 

[Joe4]

You are welcome.