If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Blank cell not really blank
I solved my dilemma.
IF($B2=48, $A2, "000000") Code() did the trick for me, thank you! |
#12
|
|||
|
|||
Blank cell not really blank
I'm not entirely clear on what is in your cell or whether the formula you
posted is what you really need or want. The CODE function (which is returning 48 for the entry 039617) is giving you the code value for the leading 0... do all your non-blank cells start with 0? Also, you are showing 32 for the code your "blank" cells... 32 *is* the code for a blank space; so your "blank" cells are not really empty, they contain at least one blank character (I guess there could be more). You could one of two things (besides what you showed us for your solution)... one, clean up your data to remove the blank characters or, two, you should be able to eliminate the helper column (the one with the CODE function in it) and use this instead... =IF(TRIM($B2)="","000000",$A2) Doing the test this way will allow entries in your Column A cells that don't start with a 0. This, of course, assumes the "blank" cells in Column A have one or more spaces in them and no other non-printable characters. -- Rick (MVP - Excel) "OperationsNETTC15" wrote in message ... I solved my dilemma. IF($B2=48, $A2, "000000") Code() did the trick for me, thank you! |
|
Thread Tools | |
Display Modes | |
|
|