Converting strings to numbers

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Converting Strings into Manus	=?Utf-8?B?QUJC?=	Microsoft VB .NET	1	23rd Mar 2005 01:41 PM
converting to excel - strings that look like numbers	Bernie Yaeger	Microsoft VB .NET	2	22nd Feb 2004 03:43 PM
converting strings to ASCII	shank	Microsoft Access Queries	2	23rd Dec 2003 01:06 PM
Converting STRINGS into FORMULAS	Dario Jardim Junior	Microsoft Excel Misc	10	21st Dec 2003 12:52 PM
PN: Converting C Strings to managed strings	Peter Nolan	Microsoft VC .NET	0	20th Nov 2003 11:01 PM