Prev: Copy to Named Range
Next: Column Array
From: Big Bitty Big on 29 Apr 2010 10:20
I want to join the values of a range of cells (say 1, 2, 5, and 8) to produce
the number 1258, which can then be used in other calculations. Any ideas on
how to do this?

I'm using Excel from Office 2000

Many thanks
From: Jacob Skaria on 29 Apr 2010 10:29
Formula
=--(C9&D9&E9&F9)

VBA code
varData = --(Range("C9") & Range("D9") & Range("E9") & Range("F9"))


--
Jacob (MVP - Excel)


"Big Bitty" wrote:

> I want to join the values of a range of cells (say 1, 2, 5, and 8) to produce
> the number 1258, which can then be used in other calculations. Any ideas on
> how to do this?
>
> I'm using Excel from Office 2000
>
> Many thanks
From: Rick Rothstein on 29 Apr 2010 10:31
You can concatenate the ranges and then convert the result to a numerical
data type...

ComboNumber = CLng(Range("A1") & Range("E5") & Range("J8") & Range("H9"))

If you told us more about your set up (will cells vary in number, are they
always contiguous, are they always in a single column, etc.), we might be
able to give you better code.

--
Rick (MVP - Excel)



"Big Bitty" <Big Bitty(a)discussions.microsoft.com> wrote in message
news:E42C8F03-43C1-457C-AB36-1740F4042748(a)microsoft.com...
> I want to join the values of a range of cells (say 1, 2, 5, and 8) to
> produce
> the number 1258, which can then be used in other calculations. Any ideas
> on
> how to do this?
>
> I'm using Excel from Office 2000
>
> Many thanks

 | 
Pages: 1
Prev: Copy to Named Range
Next: Column Array