How to convert a column of text to upper and lower case?

B

Bill Ridgeway

Two ways come to mind -

Insert a helper column and use the formula =lower(a1)
Copy and paste the whole lot into word and use <Format><Change
case><lowercase>

Strangely though it may seem I prefer the second option. It's slightly
easier and has more change options than in Excel.

Regards.

Bill Ridgeway
Computer Solutions
 
Top