Any equivalent in Excel for Shift-F3 in Word?

[Jennifer Murphy]

The Shift-F3 keyboard shortcut cycles text from lower case to upper
case to "sentence case". Is there anything similar in Excel?

 

[Dave Peterson]

Not built-in. Well, through xl2007 anyway. I haven't used xl2010.

But there are functions that can use another cell to change to lower or upper case.

=upper(a1)
and
=lower(a1)

Sentence case is much more difficult.

 

[Clif McIrvin]

Would it be worth the effort to code a macro to use automations calls to
Word with selected text? I don't have the time to pursue this, but it
might be worth looking into.

Clif

 

[Jennifer Murphy]

Not built-in. Well, through xl2007 anyway. I haven't used xl2010.

Pity. Seems like I read some Microsoft hype a long time ago about all
of the Office apps having a standard and consistent UI.

But there are functions that can use another cell to change to lower or upper case.

=upper(a1)
and
=lower(a1)

I don't have any spare cells.

Sentence case is much more difficult.

Not for Word.

 

[GS]

Jennifer Murphy wrote on 3/9/2011 :

Pity. Seems like I read some Microsoft hype a long time ago about all
of the Office apps having a standard and consistent UI.

Has nothing to do with the various features provided by each app. -Just
the look & feel of the UI.

I don't have any spare cells.


Not for Word.

Try looking on J-Walk.com. I use a set of macros (stored in
PERSONAL.XLS) I got ideas for from there that allow me to toggle case
as UPPER, lower, Proper, Or sentence.

 

[Gord Dibben]

You need a set of macros.

Sub Upper()
Dim Cell As Range
Application.ScreenUpdating = False
For Each Cell In Selection
Cell.Formula = UCase(Cell.Formula)
Next
Application.ScreenUpdating = True
End Sub


Sub Lower()
Dim Cell As Range
Application.ScreenUpdating = False
For Each Cell In Selection
Cell.Formula = LCase(Cell.Formula)
Next
Application.ScreenUpdating = True
End Sub


Sub Proper()
Dim Cell As Range
Application.ScreenUpdating = False
For Each Cell In Selection
Cell.Formula = Application.Proper(Cell.Formula)
Next
Application.ScreenUpdating = True
End Sub


Sub Sentence()
For Each Cell In Selection.Cells
S = Cell.Value
Start = True
For I = 1 To Len(S)
ch = Mid(S, I, 1)
Select Case ch
Case "."
Start = True
Case "?"
Start = True
Case "a" To "z"
If Start Then ch = UCase(ch): Start = False
Case "A" To "Z"
If Start Then Start = False Else ch = LCase(ch)
End Select
Mid(S, I, 1) = ch
Next
Cell.Value = S
Next
End Sub


Gord Dibben MS Excel MVP

 

[Jennifer Murphy]

You need a set of macros.

Sub Upper()
Dim Cell As Range
Application.ScreenUpdating = False
For Each Cell In Selection
Cell.Formula = UCase(Cell.Formula)
Next
Application.ScreenUpdating = True
End Sub


Sub Lower()
Dim Cell As Range
Application.ScreenUpdating = False
For Each Cell In Selection
Cell.Formula = LCase(Cell.Formula)
Next
Application.ScreenUpdating = True
End Sub


Sub Proper()
Dim Cell As Range
Application.ScreenUpdating = False
For Each Cell In Selection
Cell.Formula = Application.Proper(Cell.Formula)
Next
Application.ScreenUpdating = True
End Sub


Sub Sentence()
For Each Cell In Selection.Cells
S = Cell.Value
Start = True
For I = 1 To Len(S)
ch = Mid(S, I, 1)
Select Case ch
Case "."
Start = True
Case "?"
Start = True
Case "a" To "z"
If Start Then ch = UCase(ch): Start = False
Case "A" To "Z"
If Start Then Start = False Else ch = LCase(ch)
End Select
Mid(S, I, 1) = ch
Next
Cell.Value = S
Next
End Sub


Gord Dibben MS Excel MVP

Thanks, Gord, even tho your top posting makes the thread nearly
impossible to follow. ;-)

 

[Gord Dibben]

My postings for the past 11 years have been top-posted.

Too old and curmudgeonly to change now<g>


Gord

 

[Jennifer Murphy]

My postings for the past 11 years have been top-posted.

Too old and curmudgeonly to change now<g>

It just makes the thread difficult to follow and to reply to.

 

[Clif McIrvin]

... and posting quality always provokes forgiveness.

Besides, sadly (to me at least) top posting is a defacto standard (if
not
'the' standard) in the MS groups. Something to do with how outlook
defaults
to replies on top perhaps ?.

<valuable work snipped>

Second both points!

I think top-posting has to do with the shift from text-based internet to
GUI-think, and immediate convenience over long range usefulness. MS
certainly is/was a big-name player in the shift, but I don't really
believe they are the culprit "at the center of the onion" so to speak.

 

[Bruce Sinclair]

My postings for the past 11 years have been top-posted.

Too old and curmudgeonly to change now<g>

... and posting quality always provokes forgiveness.

Besides, sadly (to me at least) top posting is a defacto standard (if not
'the' standard) in the MS groups. Something to do with how outlook defaults
to replies on top perhaps ?.

<valuable work snipped>

 

[Bruce Sinclair]

It just makes the thread difficult to follow and to reply to.

Agreed (but see my other post in this thread ).

<excellent stolen example >

A: Post your responses after the portion of the message to which
you're replying.
Q: So what should we do?
A: Because it reverses the order in which we read things.
Q: Why is top-posting a bad idea?

 

[Bruce Sinclair]

Second both points!

I think top-posting has to do with the shift from text-based internet to
GUI-think, and immediate convenience over long range usefulness. MS
certainly is/was a big-name player in the shift, but I don't really
believe they are the culprit "at the center of the onion" so to speak.

Hmmm ... perhaps not ... yet areas of high MS concentration do seem to have
higher concentrations of top posting. If this sort of thing follows any
kind of diffusion model, that correlation has to be interesting at least ?


Yes, I know ... correlation is not causation ... and epidemiology is not a
science.