Currently Being ModeratedNov 6, 2012 5:35 AM (in response to Casemon)
I think I would perform a search an replace on ". a" with ". A" and repeat for each letter OR...
If you copy the text into a text editor that supports regular expressions you could perform a single search replace operation that will capture the combinations of punctuation, white space following the punctuation and first lett of the sentences.
Currently Being ModeratedNov 6, 2012 10:32 AM (in response to Casemon)
I was going to recommend that you use Devon Wordservice and do one cell at a time. However in testing I found that Wordservice doesn't capitalize the first word after a question mark when you selecgt Initial Words of a Sentence. You could use a combination of substitution and Wordservice if you don't need a comprehensive soltion.
Currently Being ModeratedNov 7, 2012 5:07 AM (in response to Casemon)
If you have Pages and Devon Wordservice, you can probably:
- Copy your table in Numbers
- Paste it into a (blank) Pages wordprocessing document
- Menu > Format > Table > Convert Table to Text
- Select all the text and apply Wordservices "Initial Caps of Sentences"
- Menu > Format > Table > Convert Text to Table
- Copy the table
- Paste it back into the Numbers table
That seemed to work for me, at least with the single column table I tried.
Currently Being ModeratedNov 7, 2012 10:31 AM (in response to Jerrold Green1)
Valid point, but at least in Pages, while it's all one block of text you can, for example, use Find… to replace all the "?" with "?." and then change the sentence case, then reverse the Find…replace to return to question marks.
(If it is an issue.)
Currently Being ModeratedNov 7, 2012 10:52 AM (in response to Jeff Shenk)
There is always that, but in that case, cells with carriage returns would be treated as separate cells when pasting back.
Yes the Devon Wordservice doesn't consider all possible endings of a sentence ! or ? and it really should (will contact author on this, as it is a popular service extension)
All of this is moot, however, as I've already gone in and manually fixed these issues. The workflow followed was this, for each upper case cell:
1) edit cell, use keyboard shortcut to assign Devon Wordservice sentence capitalization.
2) search for ! and ? and fix lower case word that follows.
Was tedious & needlessly time consuming but done & done!
Thanks for the tips guys (and ostensibly gals)!