IF Statement to input initials
 

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

IF Statement to input initials
 

=IF(B2="","",LEFT(B2,1) & ".")


No space between the first pair of double quotes
--
Gary''s Student - gsnu200767


"peg84" wrote:


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

IF Statement to input initials
 

I knew it had to be something simple! Thank you very much for your
help.

Gary''s Student;2616491 Wrote:
=IF(B2="","",LEFT(B2,1) & ".")


No space between the first pair of double quotes
--
Gary''s Student - gsnu200767


"peg84" wrote:
-

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
-




--
peg84