IF Function Help

G

Guest

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 holder’s 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,
 
T

T. Valko

You don't necessarily need an IF formula. Try this:

=LEFT(J1,3)&"0101"

You could use an IF to make sure there is an entry in column J:

=IF(J1<>"",LEFT(J1,3)&"0101","")
 

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

How to use the search in an if statement 3
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
Wildcard Searches in IF Formulas 3
Typing an adress in a form and verify if it exist in another form 3
IF function 4
Function similar to "LEFT" 3
Use Len and Left to make name 3 letters 2
SUMIFS Issue 5

Top