Avatar of Allen Barbe
Allen Barbe

asked on 

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.

Microsoft OfficeMicrosoft Excel

Avatar of undefined
Last Comment
Allen Barbe

8/22/2022 - Mon