Text causing problems?

  • Thread starter Thread starter Colin Foster
  • Start date Start date
C

Colin Foster

Hi,
I have a spreadsheet which is populated by a query using MS Query. Some
cells in a "Customer Part number" column appear to be blank, whilst others
have the customers part number. What I want to be able to do is if there is
no customer part number then I want to use "Our" part number.
However, if I search for ISTEXT, ISBLANK, or even use LEFT to pull out the
first character and check if this is a blank space (single "hit" on the
<spacebar>) to try to use "our" part number, I get an answer which indicates
that there is something in the cell, even 'though it appears to be blank.
I've found a tortuous way around this, but wonder if anyone has any ideas?
I can provide a part of the spreadsheet if anyone wants to have a play with
it.
Regards
Colin Foster
 
Just :-)
Unfortunately, that didn't work, either!
It's as though there is some text or a marker indicating text in the field,
but there does not appear to be anything that can be "latched on to". Is
there any way of checking for, for example, non printable characters?
Regards
Colin
 
Interesting...just had another play...
If I (manually) hit F2 to edit and then press enter to accept the value that
is in the "blank" cell, then I get the result that I want, even if, on the
face of it nothing changes within the cell.
Hmmm..don't ya just love Excel!
Any suggestions for creating a macro to do this which would continue all the
way down the column until it gets to the last cell?
Regards
Colin
 
Any way you can send me a snippet of your data?
I'll try to look at it - (remove 'nospam' from address)
(e-mail address removed)
 
Back
Top