Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I highlight three cells in a row with speech recognition u. | Excel Worksheet Functions | |||
IF function and speech recognition | Excel Worksheet Functions | |||
Speech Recognition and Macros | Excel Discussion (Misc queries) | |||
how do I enter numbers in excel using speech Recognition? | New Users to Excel | |||
Speech recognition | Excel Discussion (Misc queries) |