LinkBack URL
About LinkBacks
What is the easiest way to remove non-numerical values from a row of cells for processing?
What is the easiest way to remove non-numerical values from a row of cells for processing?
1) Highlight the row
2) Press F5, click on Special
3) Use the options to select "Text" for either constants or formulas
4) OK
5) Now all the numbers are highlighted, press DELETE
Last edited by JBeaucaire; 12-28-2011 at 11:39 PM. Reason: Corrected line 3
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
i am a complete newbie so please dont think I am trying to argue with you I am trying to learn,, would not what you wrote erase all numbers? I think he wanted to erase everything except the numbers?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks