top of page

Let's start this off with a formula!

Here’s a quick one to change the case of a column of text in a cell.

=Upper(your text) will change lower and mixed case entries to upper case. Talk about options, try Lower(your text) to change those pesky upper-case entries to lower case. And just in case you thought we were done, you can even change entries to sentence case with =Proper(your text).

Recent Posts

See All
Get it together.

Here is a quick way to join the contents of 2 cell and display the results in third cell. · Find an empty cell and type the “=” sign. ·...

 
 

Commentaires


Les commentaires sur ce post ne sont plus acceptés. Contactez le propriétaire pour plus d'informations.
  • X
  • Youtube
bottom of page