Concatenate unless blank

[msmetal]

I have a spreadsheet with about 60 columns, each containing a number no longer than 3 digits. I need to combined the numbers in each row into one cell with a "|" between each number. I know how to do that and am successful with that part. The complication is that for each row, there will not be a number in every cell, and when the concatenate formula is applied, I need it to "skip" or overlook the empty cells so that I don't end up with double separators with no number in between.

I've inserted or attached an example that shows in Row 1 what I get in column K when I use concatenate and all the cells contain a number. Row 2 is what I am getting when that same formula is applied and NOT every cell contains a number. Row 3 shows what I need the cell in column K to show (which I manually entered for this example). Can someone tell me how to get this result with a formula?

example.jpg

[daffodil11]

=substitute(trim(a2&" "&b2&" "&c2&" "&d2&" "&e2&" "&f2&" "&g2&" "&h2&" "&i2&" "&j2)," ","|")

I just concatenate them all with a space between, evaluate that with Trim which removes leading and trailing spaces, and makes multiple spaces into singles, and then replace all the single spaces with bar-thingies.

[msmetal]

OMG....thank you SO SO much...and you were so quick too! This is EXACTLY what I needed!! Works like charm!

[msmetal]

OMG....thank you SO SO much...and you were so quick too! This is EXACTLY what I needed!! Works like charm!

I have no idea how to "add to your rep" or give you stars or what not, but when I figure it out I will definitely do it! Thanks again!!

[daffodil11]

No problem

I'm not doing it for the glory, anywho. Glad I could help out.