Groping

[Aha]

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

 

[Jacob Skaria]

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

If this post helps click Yes

 

[Jacob Skaria]

You may use Concatenate function to combine all 4 values

OR

=A1&B1&C1&D1

If this post helps click Yes