How to change to upper case in Excel 2003

Topic

New Reply

Good evening! I have an Excel file with a mixture of names in lowercase and uppercase. How do I change them all to uppercase without using two columns? Is
there a way to change a group of highlighted cells from lowercase to uppercase in Excel, as you can do in Word?

Regards,

Dea Friloux

Reply | Quote

Replies

You could run a macro:

Code:

Sub Change2Upper()
  Dim oCell As Range
  For Each oCell In Selection
	oCell = UCase(oCell)
  Next oCell
End Sub

Reply | Quote

Good evening! I have an Excel file with a mixture of names in lowercase and uppercase. How do I change them all to uppercase without using two columns? Is
there a way to change a group of highlighted cells from lowercase to uppercase in Excel, as you can do in Word?

Regards,

Dea Friloux

If it’s a one off exercise, I’d be tempted to copy and paste into Word, do the magic with Crtl+F3 and paste the upper case text back into the column.

But I’m just lazy sometimes

Reply | Quote

Good evening! I have an Excel file with a mixture of names in lowercase and uppercase. How do I change them all to uppercase without using two columns?

If this is a one off exercise and you are prepared to use two columns temporarily then (assuming that original is in column A) you could

[*]Put =upper(A1) into the first available cell in your temporary column
[*]Drag this new cell down to fill however many rows are in the original column
[*]Select all the new cells
[*]Edit > Copy
[*]Select cell A1
[*]Edit > Paste Special > Values
[*]Clear all the cells in the temporary column

Reply | Quote