Ignore Symbols in a cell

Geo · Mar 10, 2005

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.

Jason Morin · Mar 10, 2005

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

HTH
Jason
Atlanta, GA

Don Guillett · Mar 10, 2005

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