Excel - formula returning blanks on some cells

The formula in beginning in column D2 is returning blanks on some entries and works on others.  I noticed the cell size is larger where the formula returns a blank.  Is there another formula I can use to fix this?  I had to remove several lines below the last row so please know the actual file has multiple more rows.
Who is Participating?
Naresh PatelConnect With a Mentor TraderCommented:

Open in new window

Try this
All Courses

From novice to tech pro — start learning today.