Check sibling questions

 

How to make all Data Caps?

Step 1

=Upper(Select One Cell)

 

 

Step 2

Copy Paste for all Cells

 

Step 3

Copy whole Row or Column

Paste Special at the place where required

 

Step 4

Delete Copied Cell

 

Example 1
Upper Command to Make Data in Capital Letters - Basic Formatting

Download Excel File And Try

 

Davneet Singh's photo - Teacher, Engineer, Marketer

Made by

Davneet Singh

Davneet Singh is a graduate from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths and Science at Teachoo.