Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I think I need an IF function....
I need a formula to help me split up class lists. The names are currently
"john, Doe" in A4 what I need is to have "John" in A4 and "Doe" B2. I've seen it on another forum years ago but can't find it anymore. I also have to take down all the students user names can someone provide me with a formula that can use all of the students first name and last innitial eg. johnd Tks -- A. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I think I need an IF function....
With the entry "Doe, John" in cell A1, here is how to get everything
before the comma: =MID(A1,1,FIND(",",A1,1)-1) ....and everything after the comma: =TRIM(MID(A1,FIND(",",A1,1)+1,LEN(A1))) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I think I need an IF function....
What formula can i use to combine the whole first name with the first initial
of the last name. exp. A2 A3 A4 Doe John johnd -- A. "Dave O" wrote: With the entry "Doe, John" in cell A1, here is how to get everything before the comma: =MID(A1,1,FIND(",",A1,1)-1) ....and everything after the comma: =TRIM(MID(A1,FIND(",",A1,1)+1,LEN(A1))) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
I think I need an IF function....
Try this:
=LOWER(A3&LEFT(A2,1)) However, as I think you have got your columns and rows mixed up, I think you are likely to have Doe in A2 and John in B2 and you need the formula in C2. If this is the case, then you will need this formula in C2: =LOWER(B2&LEFT(A2,1)) and you can then copy this down column C to generate other usernames from student names in columns A and B. Hope this helps. Pete Andmor wrote: What formula can i use to combine the whole first name with the first initial of the last name. exp. A2 A3 A4 Doe John johnd -- A. "Dave O" wrote: With the entry "Doe, John" in cell A1, here is how to get everything before the comma: =MID(A1,1,FIND(",",A1,1)-1) ....and everything after the comma: =TRIM(MID(A1,FIND(",",A1,1)+1,LEN(A1))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |