Combining multiple cells into a single cell

  • Thread starter Antonio Stroman
  • Start date
A

Antonio Stroman

Is there a way to combine multiple cells in Excel 2000 into a single cell.

This what I'm trying to do:

combine data from column's a b c where column a contains 12345 colum b
contains 78 column c contains 90 into a combined column that contains
1234567890

Thanks for any help on this matter.
 
N

Norman Harker

Hi Antonio!

Use:

=A1&B1&C1

But this returns the concatenation as text and not a number.

If you want a number then use:

=--(A1&B1&C1)

The double negative is the same as multiplying by -1 twice and Excel
will try (successfully) to evaluate the text as a number. Its the same
as:

=VALUE(A1&B1&C1)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
R

Roger Govier

Hi Tony

When I am doing this sort of thing, I usually creat a sheet called First and
one called Last.
I drag these sheets to the positions required to give the range of sheets I
wish to enclose.
Then the generic formula
=SUM(First:Last!yourcell) can be used in any calculations you require.

Once the sheets are in position, you can Hide the sheets if required,
without affecting the formula.
 
R

Roger Govier

Hi Tony
I've no idea how this happened, I responded to a posting of yours regarding
"Adding through Multiple Sheets"
I have re-posted it to that thread
 
Top