A question from Askville:
Excel question – is there any way to apply a function in place?
A couple of examples – I have a cell that is in lower case and I want it to be upper case. Can I apply that function to the cell? or do I have to create another column, apply the function there, copy and paste special:values to get the cell in the format I want? Or taking a cell with a name in it that isn’t “proper” – can I do that against the existing cell without having to go through all those other convulsions?
You can, but you’ll need to write a macro to do it. Something along these lines:
Sub ApplyUpper() For Each Cell In Selection Cell.Value = UCase(Cell.Value) Next Cell End Sub Sub ApplyProper() For Each Cell In Selection Cell.Value = StrConv(Cell.Value, vbProperCase) Next Cell End Sub