As Ben Collins writes in his Blog you can extract all letters and concatenate them in reverse order using an ArrayFormula:
Use =ArrayFormula(concatenate(MID(A1,LEN(A1)-ROW(INDIRECT("1:"&LEN(A1)))+1,1)) to reverse the content of A1.
This will not trigger your Google apps limits as easily as the script solution.
-> example sheet
Enter any text in this web site and get it translated as big block characters in different styles.
Just need to click on the tabs on top for selecting style: Flip, Bold, Blocky, Bubble, etc.
TArty - Generate big artful text signs
Carty - Generate BIG text art signs
Google Search is geared up to return ‘hits’ that are the same as or similar to search terms. It has so much data that a list of “what I don’t want” rather than “what I do want” would be near infinite or useless. Search has only one exclusion operator (-) and that is mainly for text (ref) though it can be used to negate some other search options, such as site:...
It is done using block element characters that look like they spell another word:
█▬█ █ ▀█▀
It is actually an ASCII art with the following characters: █ ▬ ▀
It can't be used to spell all letters of the alphabet, but you can try. Other characters can help as well.
Here I just wrote the first part of your username: █ ╔╦╗
I gave up because the R is hard to ...
Sounds like the =SPLIT function would do what you need. Given that A1 contains the text 1 coffeeextradark 240gr, then
=SPLIT(A1, " ")
(notice the space between the quotation marks)
will split the text into three cells:
1 | coffeeextradark | 240gr
In diving through the settings again looking for "keyboard shortcuts" options mentioned by w3dk, I found in "options > settings > message format" the option "Compose message in this format: HTML / Plain text" which was set to what seemed to be the default, "HTML".
Changing it to "Plain text" removes many text formatting features including indent & un-...
This is answered with respect to Outlook.com, not Outlook Web Access - sorry, my mistake!
This would seem to be a conflict on Mac OS X only.
On Windows, Ctrl+Left Arrow and Ctrl+Right Arrow are the standard keyboard shortcuts for moving forward/back one word (not Alt). And consequently hold together with Shift to make a selection. These work the same at ...
Here's what I wound up doing (though I would still love to see an in-place solution, by which I mean one that doesn't require the use of additional cells):
I created two additional tabs (worksheets). In the first I put =split(A!A1," "), which yielded a row of words, one per cell. I called that worksheet "split". In the second I put =if(not(regexmatch(text(...
Well I have played a bit around, and WhatsApp is really not consistent between various media. The ZWJ answer (copy ZWJ here), imho the best, looks fine in iOS (and apparently on Android according to Julien Ehrhart), but will still result in bold on the web interface.
So for me, none of the solutions is really satisfying. Here is the workaround I found: ❊...
The way I fix it only in the live page is by adding a special tag to each Arabic post (for example tag arabic) then in theme CSS I add:
You can add that CSS line through your theme (most new theme settings have a page where you can add custom CSS).
For the WYSIWYG text editor, you can use this plugin:
You basically have two ways to add plain text:
Double click on the canvas (or hit Ctrl+Shift+X) to insert a non-linkable text block, and start typing
Insert the text symbol (from General menu), and start typing
Any element can also have text, or be replaced into a pure text element by Alt-dragging the text element onto the other element.
Do note that the ...
the weekdays will always be abbreviated exactly as shown,
are the entire cell content (not part of a longer string) and
data is in ColumnA,
the following may serve:
with the insertion of other search strings to suit.
Google Mobilizer provides mobile-friendly version of most webpages. You can adapt this Google Mobilizer Bookmarklet that I wrote from myself to view just the text of web pages or adapt Chrome/Opera's search provider feature to make a URL open automatically with Google Mobilizer.
Google Mobilizer will not mobilize a page if the page is already a mobile page, ...
It depends what you mean by "text editor".
If you want an osx gmail client that has solid, wysiwyg editing capabilities (and a really nice user interface, try Sparrow. Google bought them, but it still seems well-supported enough.
If you meant a true plaintext editor, there are a ton, but I find both Byword and iaWriter to be minimal enough to kill ...
As Dillie-O mentioned, they intentionally prevent text selection. This is annoying for those of us who select text as we're reading.