top of page

Capitalize Excel


Recently I was working on preparing an index of exhibits in an Excel spreadsheet of documents listed in an Affirmation filed in support of a summary judgment motion. I used the Text to Columns Wizard to separate out language such as:

Attached hereto as Exhibit 23 is a true and correct copy of excerpts of the transcript of the deposition testimony of John Smith, dated July 4, 2014.

. . so that the Exhibit number was in one column, and the actual description beginning, "transcript of the . . ." was in another column. However after doing this I was left with the problem that the first letter of the description was not capitalized. I found a solution to this problem at: http://howtouseexcel.net/how-to-capitalize-the-first-letter-in-a-cell-in-excel. Use this formula:

=REPLACE(A1,1,1,UPPER(LEFT(A1,1)))

'A1' being the cell containing the description

1 being the position of the character in A1 you want to capitalize

1 being the number of characters to captialize

UPPER (LEFT(A,1) focuses the formula on the first character in A1 and gives the number of characters you want the formula to operate on.

So if you use:

=REPLACE(A1,1,2,UPPER(LEFT(A1,2)))

You would get the first two letters in cell A1 capitalized.

replace.png


 
 

Sean O'Shea has more than 20 years of experience in the litigation support field with major law firms in New York and San Francisco.   He is an ACEDS Certified eDiscovery Specialist and a Relativity Certified Administrator.

The views expressed in this blog are those of the owner and do not reflect the views or opinions of the owner’s employer.

If you have a question or comment about this blog, please make a submission using the form to the right. 

Your details were sent successfully!

© 2015 by Sean O'Shea . Proudly created with Wix.com

bottom of page