Making IF-sentence with empty cells with spaces

[Spec]

Hi,

Thank you for the forum! I am working on a ExCel-raport where we retrive the data via a query.

Now I want to have a formula telling me (here I have used "It works) if all the necessary cells has values.

I thought I fixed it by using:
=IF(AND(D1<>"";E1<>"";F1<>"";G1<>"";H1<>"");"It works";"")
however, some of the cells being downloaded to the ExCel-sheet is empty, but contains spaces. How do I then know that the necessary cells contains values (some contains letters, some numbers), but not spaces?

The meaning by the report is that is should be automated, so I can't go in and mark the cells and delete the spaces everytime it retrives data with the query

If anyone has a good solution, please yell out

Thanks!

 

[Z51]

Maybe...

=IF(TRIM(D1&E1&F1&G1&H1)="","It works","")

 

[Spec]

Hi,
I need all necessary cells to contain a number or text before it is valid.

F.ex
D1,E1,F1,G1,H1 all needs to contain number or text to be valid. If any of those cells does not contain a value or spaces, the cell with the formula should be blank ("")

 

[Spec]

I might have solved it myself :O

=IF(AND(TRIM(D1)<>"";TRIM(E1)<>"";TRIM(F1)<>"";TRIM(G1)<>"";TRIM(H1)<>"");"It works";"")

 

[Z51]

Then maybe:

=IF(SUMPRODUCT(--(LEN(D1:H1)>0),--(TRIM(D1:H1)<>""))<5,"","It works")