Does anyone know a way to achieve the following in Excel?
=IF(K2 NUMERIC, 0&K2&W$2, "")
The problem seems to be the NUMERIC part.
Does anyone know if we had a Windows Support area in this forum or was that the old one?
???
Hi Mike,
I'm not quite sure if this is what you are looking for but, you could try the following:
IF(CELL("type",K2)="v", 0&K2&W$2, "")
(ie: if cell K2 is numeric, them display the info, else Blank)
Sorry if I misunderstood your question, a bit too cryptic for me.
My brain must have slipped back into programmer mode, sorry about that.
I'm creating a fax out using a customer MS Excel database and need to skip some of the people.
The column that will trigger the condition is a mix of alpha and numeric. Fax numbers or instructions.
Only the numeric ones are needed. No need to fax the ones that want letters but need to keep the rest of their details.
The numeric ones need to be inserted into an email address but that part is no problem. These are then emailed to the Fax Server.
So the column may have 0391234567 type numbers or something like 'Post Only' or similar, without the quotes of course.
So I was looking for a way to eliminate the text only cells in that column while keeping all the other customer details.
The problem is, I can't find a way to activate or trigger the "IF Condition" or something similar, to blank-out the new cell.
So the =IF(K2 NUMERIC, 0&K2&W$2, "") all works accept the NUMERIC condition. Does Excel 2007 have any operator that is specifically numeric or does it need to be checked some other way?
I spent quite some time on Google and the results did not include anything about separating alpha and numeric.
Thanks LawryB, I'll do that when I drop around to their place again next week. I thought it would be something like that. Plus one.