CORRECT AMERICAN DATES
USA dates are month/day/year.
With original form as MM/DD/YY use:
=MID(cell,4,3)&LEFT(cell,2)&RIGHT(cell,3)
With original form as MM/DD/YYYY use:
=MID(cell,4,3)&LEFT(cell,2)&RIGHT(cell,5)
TRIM PREFIX FROM SHEET NUMBER
When sheet number is 4 numbers:
=RIGHT(cell,4)
ADD PREFIX TO SHEET NUMBER
="prefix"&cell
e.g. ="SK"&C1
CONVERT TO UPPERCASE
=UPPER(cell)
CONVERT TO LOWERCASE
=LOWER(cell)
CONVERT TO PROPER CASE (leading capitals)
=PROPER(cell)
REMOVE FROM END OF NAME
For example view names with a prefix of (1):
=IFERROR(IF(SEARCH("text",cell)>0,LEFT(cell,(SEARCH("text",cell))-1),""),cell)
e.g.
=IFERROR(IF(SEARCH("(1)",C24)>0,LEFT(C24,(SEARCH("(1)",C24))-1),""),C24)
To remove and replace:
=IFERROR(IF(SEARCH("text",cell)>0,LEFT(cell,(SEARCH("text",cell))-1)&" replacementText",""),cell)
e.g.
=IFERROR(IF(SEARCH("(1)",C24)>0,LEFT(C24,(SEARCH("(1)",C24))-1)&" PLAN",""),C24)