Excel - formula returning blanks on some cells

Hi,
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.
Book2.xlsx
Wonderwall99Asked:
Who is Participating?
 
Naresh PatelConnect With a Mentor TraderCommented:
=RIGHT(TRIM($A2),1)

Open in new window


Try this
0
All Courses

From novice to tech pro — start learning today.