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