• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 39
  • Last Modified:

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
0
Wonderwall99
Asked:
Wonderwall99
1 Solution
 
Naresh PatelTraderCommented:
=RIGHT(TRIM($A2),1)

Open in new window


Try this
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now