Groping

  • Thread starter Thread starter Aha
  • Start date Start date
A

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
 
=SUM(A1:D1) will sum it up
=A1&"-"&B1&"-"&C1&"-"&D1 will return the string

If this post helps click Yes
 
You may use Concatenate function to combine all 4 values

OR

=A1&B1&C1&D1

If this post helps click Yes
 
Back
Top