Monthly Archives December 2017

Suppose your worksheet has text values in the format “firstnameLASTNAME” and the user would like to separate the two names into two separate columns as determined by the case of the text. The key is to determine where the text switches from lowercase to UPPERCUASE. To do this, you need to use an array formula.
Read More