Converting strings to numbers

B

Big Bitty

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
 
J

Jacob Skaria

Formula
=--(C9&D9&E9&F9)

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

Rick Rothstein

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.
 
Top