Currently Being ModeratedOct 21, 2013 3:15 PM (in response to hotwheels 22)
hotwheels 22 wrote:
... but can i ask you this?
once installed is this going to let me change something that is in ALL CAPS LIKE THIS to lower case or is it only going to change the first letter of each word in cases where the words themselves are capitalized...?
As I noted in my last post, there is an option for Initial cap of Sentence. I'm intentionally talking around the obvious solution for a spreadsheet app, the use of a Function. If your all-upper case string is in A, you can write:
to get the same text in all lower case. To turn that from the result of an Expression in a Cell to straight text, Command-C then Edit > Paste Values.
I think we already covered that, but just in case it slipped between the cracks, I've repeated it.
Currently Being ModeratedOct 21, 2013 3:41 PM (in response to Jerrold Green1)
oof. thanks jerrold. i think your level of expertise is a bit above mine when it comes to numbers and functions.
i have redone all of this by hand but basically i was hoping there was a way to make all my cells (i think i had a thousand of them with multiple words in each) magically change to lower case. so if in column 1 row 1,2 and 3 i had:
i was hoping to easily get:
wayne was kind enough to point out that there is a pulldown menu in Pages to do this - and somehow i was remembering that i did this one very easily - and i was hoping there would be a way to do this in numbers.
anyway, knowing that i need to keep my eye out for Services that will streamline other workflows may be as good a tip as i have had on the forum in a long time so THANKS.
i'll keep trucking and i very much appreciate your trying to get me sorted on this one. i think my expertise level hindered me in finalizing it to some extent.
Currently Being ModeratedOct 21, 2013 5:11 PM (in response to hotwheels 22)
"there is a pulldown menu in Pages to do this"
The menu items, found in the Format menu, change only the format in which the underlying text is displayed.
The functions UPPER() and LOWER() replace the text with its UPPER or LOWER case equivalent.
Lower, part of Devon Word Service, tested in Pages, also replaces the text.