![]() |
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