| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Function Help
Thanks, Mike!
=LEFT(J1,3)&"0101" works great! -- John "Mike H" wrote: Maybe =LEFT(J1,3)&"0101" Mike "Training Spec." wrote: I am creating an Excel spreadsheet to track permit holders. I need to assign user IDs to the first three letters of the last name of the permit holders. The column for the permit holder's name is column J. In column I, I need a formula to take the first three letters of the permit holders last name and add 0101 to it. Example: I J smi0101 Smith I know that there is an IF function that could do this, but I have had no success in making it work. Can you help? Thanks, -- John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Threaded Mode
