Here Are A Few Examples Of How You Can Use Excels Text Functions To Extract Parts Of Peoples Names From A List. The Same Formulas Could Also Be Used On Any Text, They Don't Have To Be Names
| Full Name | Formula Used | Result |
| A2=David Hawley | =LEFT(A2,FIND(" ",A2)) | David |
| A3=Ray Goodwin | =MID(A3,FIND(" ",A3,1)+1,LEN(A3)) | Goodwin |
| A4=Graeme Dee | =LEFT(A4)&MID(A4,FIND(" ",A4)+1,1) | GD |
| A5=Suzanne Greenhouse | =LEFT(A5)&MID(A5,FIND(" ",A5),LEN(A5)) | S Greenhouse |
| A6=Fred Baker | =LEFT(A6,FIND(" ",A6))&MID(A6,FIND(" ",A6)+1,1) | FredB |
| A7=Mary Hardwick | =MID(A7,FIND(" ",A7,1)+1,LEN(A7)) & " " & LEFT(A7,FIND(" ",A7)) | Hardwick Mary |
| A8=Banana | =LEN(A8)-LEN(SUBSTITUTE(A8,"a","")) | 3 i.e occurence of "a" |
No comments:
Post a Comment