linking spreadsheets and reporting initials

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?

It worked ok but it only reported the first 2 letters of the first name instead of the initials.

I came up with this but how do I get it to not report #value when the cell is blank?

LEFT('CS Clinical Rev'!C5,1)&MID('CS Clinical Rev'!C5,FIND(" ",'CS Clinical Rev'!C5,1)+1,1)&IF(ISNUMBER(FIND(" ",'CS Clinical Rev'!C5,FIND(" ",'CS Clinical Rev'!C5,1)+1)),MID('CS Clinical Rev'!C5,FIND(" ",'CS Clinical Rev'!C5,FIND(" ",'CS Clinical Rev'!C5,1)+1)+1,1)," ")