List of numbers vertically which I need vertically next to each other separated by a '|'

Hi,

I have a list of numbers vertically which I need placed next to each other separated by a '|' figure.

107918
107919
107920
107921
107922
107923
107924

Can anyone advise me on how to do this?

Thanks

David

=CONCATENATE(A2,"/",A3,"/",A4,"/",A5,"/",A6,"/",A7,"/",A8)

Outcome is: 107918/107919/107920/107921/107922/107923/107924

Is this what you want?

I have over 1000 items vertically, so I'd rather not have to type them all out, is it possible to group them?


Many Thanks

David

Hi David

Or

Formula:

Please Login or Register  to view this content.

If you upload some sample data, might give us a better idea how your sheet is set out. With your expected results.

I have over 500 rows down, though.

I don't want to have to type CONCATENATE 500 times.

I want to CONCATENATE the rows A1:A500, while also putting a | symbol between each and every one.

Sorry if I haven't been clear.

Thanks

David