#1   Report Post  
Posted to microsoft.public.excel.misc
cjaynes
 
Posts: n/a
Default speech recognition


Hi,
I'm using MS Office 2003, and I've just started using Speech Recog.
since I've injured a hand. In Excel, I'm trying to address two issues:
I want Excel to capitalize the first letter of every word (proper), but
I haven't found good instructions on how to apply that to the entire
worksheet. Also, I need to use the word "microphone" quite a bit, which
of course, turns off the micropone. I haven't yet found out how to
disable that function, or how to create a substitute word to use
instead. For example, I'd be glad to say 'mphone' and have Excel type
'microphone', but I haven't found that option yet.

Thanks in advance!
chet


--
cjaynes
------------------------------------------------------------------------
cjaynes's Profile: http://www.excelforum.com/member.php...o&userid=32362
View this thread: http://www.excelforum.com/showthread...hreadid=521196

  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default speech recognition

Hello, Chet-
I was trying to find a way to format or otherwise rig a cell to enter
any text input with the first letter of every word capitalized
("Proper" case), and couldn't do it. As an alternative, how would you
feel about running a macro? The macro that follows will change
"mphone" to "microphone" (you can change that if you need to) and then
converts all text to Proper case.

You'd need to run this macro after every input session. Depending on
how you feel about that sort of thing, we could arrange to run the
macro every time a cell is changed or updated. Let us know what you
think.

Sub All_Caps()
Dim rCell As Range

'replace "mphone" with "microphone"
Cells.Replace What:="mphone", Replacement:="microphone",
LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False

'convert all to proper case
For Each rCell In ActiveSheet.UsedRange
rCell.Value = StrConv(rCell.Value, vbProperCase)
Next rCell
End Sub

  #3   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie
 
Posts: n/a
Default speech recognition

You may regret having asked two completely different questions in the
same post, can't help you with speech recognition.

As far as proper case goes see my page
http://www.mvps.org/dmcritchie/excel/proper.htm

You can use a worksheet function -- not recommended unless you want
to always see the original and a changed version.

You can correct everything at once, whether it is a cell, group of cells,
a column, the entire page (ctrl+A)

You can use an Event macro to correct the entries as soon as entered

I would suggest the second method because you can customize which words
might need special attention McRitchie, IBM, Tale of Two Cities

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"cjaynes" wrote in message
...

Hi,
I'm using MS Office 2003, and I've just started using Speech Recog.
since I've injured a hand. In Excel, I'm trying to address two issues:
I want Excel to capitalize the first letter of every word (proper), but
I haven't found good instructions on how to apply that to the entire
worksheet. Also, I need to use the word "microphone" quite a bit, which
of course, turns off the micropone. I haven't yet found out how to
disable that function, or how to create a substitute word to use
instead. For example, I'd be glad to say 'mphone' and have Excel type
'microphone', but I haven't found that option yet.

Thanks in advance!
chet


--
cjaynes
------------------------------------------------------------------------
cjaynes's Profile: http://www.excelforum.com/member.php...o&userid=32362
View this thread: http://www.excelforum.com/showthread...hreadid=521196



  #4   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie
 
Posts: n/a
Default speech recognition

Misread the second part thought you were asking about Speech Recognition.
Another possibility besides that supplied by Dave O., would be to use
Tools, Autocorrect and add mphone to be changed to microphone


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I highlight three cells in a row with speech recognition u. evm Excel Worksheet Functions 0 December 13th 05 02:07 AM
IF function and speech recognition slcbabe Excel Worksheet Functions 0 October 12th 05 04:02 PM
Speech Recognition and Macros G118 Excel Discussion (Misc queries) 0 September 12th 05 04:12 PM
how do I enter numbers in excel using speech Recognition? merouehchady New Users to Excel 0 April 24th 05 04:38 PM
Speech recognition Speech regonize Excel Discussion (Misc queries) 1 February 2nd 05 02:35 AM


All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"