Thread: identify a record that has a blank space in the data in a field.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default identify a record that has a blank space in the data in a field.
The following formula will tell you if a cell has blanks in it:

=IF(SUBSTITUTE(A1," ","")=A1,"no blanks","has blanks")


--
Gary's Student


"JH" wrote:

I need to pull records that have a blank space somewhere in the data , for
example "type 1" as opposed to "type1" or "help me" as opposed to "helpme".
Your help is much appreciated.
Reply With QuoteReply With Quote