how do I change the letters

G

Guest

I wrote in the cells miniscule letters now I want to change the majuscule
letters , somebody knows how to do it?
 
A

Andy Pope

Hi,

Assuming miniscule means lowercase and majuscule means UPPERCASE, you
can use a helper column and then copy and paste values.

lowercase text in A1 would use this formula in B1

=UPPER(A1)

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to type each letter of the alphabet automatically in a specific color in Word? 0
Formular to count occurence of a number or letter in a column 2
Restricting Cell entry to certain letters 7
Simple calculation where values change to letters? 3
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
I WANT TO INSERT A LETTER IN FRONT OF A NUMBERS 5
Custom Formating Letters to Numbers while Displaying Letters 2
Columns labeled with numbers not letters 8

Top