=SUM(A1:D1) will sum it up
=A1&"-"&B1&"-"&C1&"-"&D1 will return the string

If this post helps click Yes
---------------
Jacob Skaria


"Aha" wrote:

Hi,

suppose i have 2500 1 2 3 in cell a b c &d, how can i consolidate them to
say 250123 or 250-1-2-3.

please help