Ignore Symbols in a cell

In cell I4 I have the value (# 6) and in cell I10 I have just a number ...say
60. I would like to divide cell I10 by Cell I4. I get a value error.
--
Geo

try
=SUBSTITUTE(i4,"#","")+2

--
Don Guillett
SalesAid Software
donaldb@281.com
"Geo" <Geo@discussions.microsoft.com> wrote in message
news:BFB3C8F8-FAFC-4D1A-96D6-3945C03D0E0B@microsoft.com...
> In cell I4 I have the value (# 6) and in cell I10 I have just a number
....say
> 60. I would like to divide cell I10 by Cell I4. I get a value error.
> --
> Geo

=I10/SUBSTITUTE(I4,"# ","")

HTH
Jason
Atlanta, GA

>-----Original Message-----
>In cell I4 I have the value (# 6) and in cell I10 I have
just a number ...say
>60. I would like to divide cell I10 by Cell I4. I get a
value error.
>--
>Geo
>.
>