ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   removing symbols from numbers (https://www.excelbanter.com/excel-programming/290747-removing-symbols-numbers.html)

Chris

removing symbols from numbers
 
Hello,
I have a problem with removing objects from numbers. The
first problem is that I would like to remove a # symbol
and just get the real value.
For example I have values of #4 and #15 and would like it
to read just 4 and 15.

The other problem is that I have numbers such as 185/10
and 45/0 and so forth. I would only want the whole value
185 and 45 and not the symbol / or anything after it.
Can you help me.

Thank you

Chris


All times are GMT +1. The time now is 03:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com