No Dashes, please?
 

how do i use the value of a cell without the dashes?

For example

range(A1) = "123456-4434"

i want to use that number in an equasion as "1234564434"

thanks

No Dashes, please?
 

One way:

=SUBSTITUTE(A1,"-","")+1

In article ,
"Patrick" wrote:

how do i use the value of a cell without the dashes?

For example

range(A1) = "123456-4434"

i want to use that number in an equasion as "1234564434"

thanks

No Dashes, please?
 

Hi
try
ret_var=CDbl(Replace(range("A1").value,"-",""))

--
Regards
Frank Kabel
Frankfurt, Germany


Patrick wrote:
how do i use the value of a cell without the dashes?

For example

range(A1) = "123456-4434"

i want to use that number in an equasion as "1234564434"

thanks

No Dashes, please?
 

=SUBSTITUTE(A1,"-","")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Patrick" wrote in message
...
how do i use the value of a cell without the dashes?

For example

range(A1) = "123456-4434"

i want to use that number in an equasion as "1234564434"

thanks