IF Statement to input initials

  • Thread starter Thread starter peg84
  • Start date Start date
P

peg84

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 fo
the last initial. What I want is to leave the cell blank if I do no
have the last name but, if I do, insert the first letter of the las
name along with ".". The formula I have it =IF(B1=" ",
",((LEFT(B1,1)&"."))). It does put the first letter and "." in th
cell but will not leave blank if no last name. Any idea what I a
doing wrong
 
=IF(B2="","",LEFT(B2,1) & ".")


No space between the first pair of double quotes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF Statement question 3
I need to take partial information from two columns and then add t 2
List if 3
Last initial 14
Is it possible 5
Logical functions IF & AND 1
Formula To Split Name 5
IF Statement Help 6

Back
Top