MS Excel Issue

In cell A2 I have it set up as Name.  I would like cell E2 to reflect the same entry automatically (I put in cell E2 =A2).  =A2 works but when cell A2 is blank there is a '0' in E2.  Can anyone assist in correcting this as I would like cell E2 to be blank until cell A2 is filled with data.  Attached is the example.

Thank you in advance.

Allen BarbeAsked:
Who is Participating?
Ejgil HedegaardConnect With a Mentor Commented:
Use this
Allen BarbeAuthor Commented:
Formula worked perfectly.  Thank you!
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.

All Courses

From novice to tech pro — start learning today.