I have a spreadsheet where I have the first name in the first column,
then the last name in the next column. I am inserting a new column for
the last initial. What I want is to leave the cell blank if I do not
have the last name but, if I do, insert the first letter of the last
name along with ".". The formula I have it =IF(B1=" ","
",((LEFT(B1,1)&"."))). It does put the first letter and "." in the
cell but will not leave blank if no last name. Any idea what I am
doing wrong?




--
peg84