Leading the way in Microsoft Office Development

Please contact us if you have any useful formulas we can add to this page.

To make a contribution to this website please e-mail us. feedback3@bettersolutions.com

1) Determining if a cell contains text

=ISTEXT(A1)=TRUE

=ISTEXT(B1)=FALSE

2) Determining if two strings are identical

=EXACT(A1,B1)=FALSE

=A1=B1=TRUE

=EXACT(A2,B2)=TRUE

3) Obtaining the first word from a string

=LEFT(A1,FIND(" ",A1))="Russell"

=LEFT(B1,FIND(" ",B1))="Microsoft"

4) Obtaining the last word from a string (when there are 2 words)

=MID(A1,FIND(" ",A1,1)+1,LEN(A1))="Proctor"

=MID(B1,FIND(" ",B1,1)+1,LEN(B1))="Office Development"

5) Obtaining the initials (or first characters of each word)

=LEFT(A1)&MID(A1,FIND(" ",A1)+1,1)+"RP"

=LEFT(B1)&MID(B1,FIND(" ",B1)+1,1)+"BS"

6) Changing the order of the 2 words

=MID(A1,FIND(" ",A1,1)+1,LEN(A1))&" "&LEFT(A1,FIND(" ",A1))="Proctor Russell"

=MID(B1,FIND(" ",B1,1)+1,LEN(B1))&" "&LEFT(B1,FIND(" ",B1))="Solutions Better"

7) Changing the text to uppercase

=UPPER(A1)="BETTERSOLUTIONS.COM"

=UPPER(B1)="BE MORE PRODUCTIVE"

8) Changing the text to lowercase

=LOWER(A1)="bettersolutions.com"

=LOWER(B1)="be more productive"

9) Changing the first letter of every word to uppercase

=PROPER(A1)="Microsoft Office Development"

=PROPER(B1)="Better Solutions"

10) Obtaining everything to the right of a dash

=RIGHT(A1,LEN(A1)-FIND("-",A1))="Proctor"

=RIGHT(B1,LEN(B1)-FIND("-",B1))="Development"

11) Repeating a character or string a number of times

=REPT(A1,3)="better-better-better-"

=REPT(B1,5)="@@@@@"

12) Removing the extra spaces at the front

=TRIM(A1)="Russell Proctor"

=TRIM(B1)="BetterSolutions.com"

13) Obtaining the last word from a string (when there are at least 2 words)

=RIGHT(A1,LEN(A1)-FIND("#",SUBSTITUTE(A1," ","#",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))="Development"

=RIGHT(B1,LEN(B1)-FIND("#",SUBSTITUTE(B1," ","#",LEN(B1)-LEN(SUBSTITUTE(B1," ","")))))="PowerPoint"

14) Obtaining the last word from a string (when there may only be one word)

=IF(LEN(A1)-LEN(SUBSTITUTE(A1," ",""))=0,A1,RIGHT(A1,LEN(A1)-FIND("#",SUBSTITUTE(A1," ","#",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))))="Microsoft"

=IF(LEN(B1)-LEN(SUBSTITUTE(B1," ",""))=0,B1,RIGHT(B1,LEN(B1)-FIND("#",SUBSTITUTE(B1," ","#",LEN(B1)-LEN(SUBSTITUTE(B1," ",""))))))="PowerPoint"