I'm have 2 spreadsheets in the same work book and when text is entered into one I would like it to add the same text to another cell in another sheet. Specifically is there a way to report a person initials from a cell containing their full name?