Hi guys
I have a sheet (example attached) I need a formula to recognise only the numeric values either by automatically deleting the words or by entering the numbers in another corresponding sheet, either would do.
thanks
David
Hi guys
I have a sheet (example attached) I need a formula to recognise only the numeric values either by automatically deleting the words or by entering the numbers in another corresponding sheet, either would do.
thanks
David
Hello,
Please check the attached file, let me know if that help you.
Regards,
Alvaro
That's perfect amromerodiaz thank you very much.
@Davycc
Please note that numbers received by using LEFT/RIGHT/MID/SUBSTITUTE function always return numbers as text. To convert them to real numbers use formula like this:
=LEFT(B1,1)+0
Last edited by AlKey; 07-23-2014 at 09:00 AM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thanks Alkey, that's why my sum etc wasn't working lol
You're welcome and thank you for the feedback!
Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools -> Mark thread as Solved).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks