Microsoft excel formula

[Kim K]

enter the name Kim in A7 Name will also come up in A14 on same worksheet

 

[Gary''s Student]

In A14 enter:

=IF(A7="","",A7)