Hi all,

I have an Excel 2010 worksheet which contains numbers in Cell A1 to Z1. I need to merge all the numbers in those cells into one single cell but each number need to be separated by the "|" sign.

I know the Concatenate formula [=concatenate(A1,"|",B1,"|",C1.....] can do this but it will be tedious to write, given I am merging a large number of cells. Is there a variation to this formula that can perform this task? Or may be a different formula?