I have a formula in a cell that returns # value. The formula is
=CONCATENATE(D9," ",E9,F9,)

The Column D is formated to Text and both E and F are General. My problem is
that when I type a value in E9, the #Value! is returned

Any ideas on whats causing this?