Combining multiple cells into a single cell

  • Thread starter Thread starter Antonio Stroman
  • Start date 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.
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
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.
 
Hey Roger, this message from you was appended to a response I had to
someone lese about their problem instead of to my original question
about referenccing the current tab name. I responded over there.

Thanks,
Tony
 
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
 
Back
Top