Column D has either 4 letters or 4 numbers in it. I need to make the field blank if it is letters and keep only the fields with the numbers. I thought I could do some formula in another column with an if statement, but I can't seem to come up with a solution.
Last edited by Annelie; 08-17-2010 at 08:27 AM.
Annelie
=if(isnumber(a1), a1, "")
Entia non sunt multiplicanda sine necessitate
try this
Please Login or Register to view this content.
Last edited by Mordred; 08-14-2010 at 05:58 PM.
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
Sorry shg, you beat me to it.
Both solutions work great. Mordred's answer, for this project would be better, because I do not have to create a new column. However, the routine must stop at the last row. Can I get more help with that?
Numerous routes - one which avoids cell by cell iteration would be:
edit:Please Login or Register to view this content.
If the values are constants, true numeric values and pending number of non-contiguous ranges you might get away with
Please Login or Register to view this content.
Last edited by DonkeyOte; 08-16-2010 at 11:05 AM.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks