ExcelBanter - Ignore Symbols in a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Ignore Symbols in a cell (https://www.excelbanter.com/excel-discussion-misc-queries/17020-ignore-symbols-cell.html)

Geo

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

Jason Morin

=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
.

Don Guillett

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

--
Don Guillett
SalesAid Software

"Geo" wrote in 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

All times are GMT +1. The time now is 09:51 AM.