| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If..The Statement to automatically format a name
I am looking for an Excel if..then statement to evaluate a name and insert a
period after a single letter if the name contains a single letter. Example John Q Smith. Can excel do this for a list of names that are not the same length. Please help. These are more examples. John T James Janice S Smith Lola P Simpson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If then statement and time format | Excel Discussion (Misc queries) | |||
| If statement and cell format | Excel Discussion (Misc queries) | |||
| if statement format cell | Excel Worksheet Functions | |||
| Not sure how to format this if statement | Excel Discussion (Misc queries) | |||
| How to add date format into if statement? | Excel Discussion (Misc queries) | |||
Threaded Mode
