| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Period After Initials | Excel Worksheet Functions | |||
| Create initials from Full name | Excel Discussion (Misc queries) | |||
| how can I change input statement to show only stars for password **** | Excel Discussion (Misc queries) | |||
| Using a Input Box Value in an if statement | Excel Discussion (Misc queries) | |||
| How to pluck out initials of a 2 or 3 word name | Excel Worksheet Functions | |||
![peg84[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
