Thread: casing
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rodchar
 
Posts: n/a
Default casing

thank you.

"John Michl" wrote:

rodchar -
Set up a dummy column and use the LOWER function as = LOWER(A1). Then
Copy Paste Special Values to convert that new column to values
only. Copy those over the original column and delete. If you need to
do this frequent, you'd need to write a half dozen lines of VBA.

- John Michl