ExcelBanter - Groping

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Groping (https://www.excelbanter.com/excel-worksheet-functions/225733-groping.html)

Aha

Groping

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

Groping

=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

Jacob Skaria

Groping

You may use Concatenate function to combine all 4 values

OR

=A1&B1&C1&D1

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

All times are GMT +1. The time now is 10:16 AM.