user function concatenation of two columns into single cell

I want to have a user defined function named concall(Range1, Range2) that will let me first concatenate text in two columns with a new line into a single cell.

Suppose if data in A1 to A3 is
A
B
C

and C1 to C3 is as follows
Alpha
Beta
Gamma

If I enter concall(A1:A3, C1:C3) in Cell F3, it should display the following in Cell F3

A – Alpha
B – Beta
C – Gamma

I know how to concatenate row-wise data to a single cell

Please Login or Register  to view this content.