Questions tagged [text-formatting]

Use this tag for questions about the appearance of text beyond the use of a standard character set in its simplest form. This includes: highlighting or colour, to draw attention; cursive, for informality; and other aids to the reader such as italic rather than Roman, eg for book titles, or monospaced, eg for code, and size, kerning, direction, small caps, strikethrough etc. Note tags [highlight], [special-characters] and [emoji] exist.

Filter by
Sorted by
Tagged with
1
vote
1answer
32 views

Assert cell style onto text pasted into that cell

I'm not quite sure how to word this so I couldn't find any answers to my question after some searching. I am trying to copy and paste values into my Google sheet. These values are copied from another ...
1
vote
1answer
13 views

Adding mm:ss times when expressed as TEXT

I have a series of numbers that, for a reason out of my control I can not change, are expressed as plain text strings on google sheets. The numbers are supposed to be minute second. mm:ss. For the ...
1
vote
0answers
362 views

Smart quotes in Google Blogger

I would like to have Google Blogger automatically make the apostrophes and quotes in my posts curly, as word processors do. For example, I want to type this: and get this: I mostly use Firefox on ...
0
votes
2answers
44 views

Google Sheets duration format does wrap around 24

If I format the cells of a sheet to duration, it wraps around 24h So adding those three cells (which should represent HH:MM): 05:00 18:00 02:00 with SUM, the result is 01:00 where I need the result ...
0
votes
1answer
141 views

What DTP does Wikipedia use for PDF export?

When viewing any Wikipedia article, it is possible to export the article to a number of formats, including PDF. My instinct told me they would use some TeX system (plainTeX, LaTeX, ConTeXt, etc.), ...
0
votes
1answer
24 views

Combine cells retaining formatting within a sheet

I want to combine columns of texts while preserving the formatting (e.g., underline, italics). How can I do that? I know how to use =C1&CHAR(10)&C2 ... but the formatting is lost.
0
votes
1answer
233 views

Google Sheets Custom Number Format - Unchanging #<1000

I am well aware of the excellent Custom Number Formula: [<999950]0.0,"K";[<999950000]0.0,,"M";0.0,,,"B" Which abbreviates #,000 numbers to #K, #,000,000 to #M etc... However, I am looking for ...
0
votes
1answer
610 views

Google Docs copy paste formatting / indent question

So say I am taking a YouTube transcript, and copying the whole thing, and then pasting it into a document. The way the transcript is set up with YouTube it's layered like every 5 seconds so its lines ...
0
votes
1answer
37 views

Google Doc - applying headers to single line only - after pasting as plain text

The issue: https://youtu.be/OXS3wTR7YJw Make notes in "Notes" (better for offline) Paste into Google Doc Apply a header Sh!t the whole thing is formatted now Related but not the same: Create ...
0
votes
3answers
1k views

Increase font size in Google search results

Can I increase the font size in Google search results? I already searched everywhere, but still didn't get an answer
0
votes
0answers
22 views

Formatting math formulas in Google Docs -nesting multiple levels of superscript and subscript

Does anyone know if Google Docs supports nested superscripts and subscripts like the following?     Ax3     Cx2 When I try it using the Format->Text menu ...
0
votes
1answer
27 views

Cannot get rid of some space/margins

I'm working on my resume in Google Docs (Word processing) and I'm trying to add my name + personal information at the top, but I'm seeing a line of space above it. As you can see, I'm trying to get ...
0
votes
0answers
22 views

Force Gmail to always paste text without rich format [duplicate]

As in question, is it possible to force Gmail to always paste unformatted text? It gets me a little bit crazy that I always have to go with copied text through some middle app (like Notepad, Windows' ...
0
votes
1answer
55 views

Funny alignment in Google spreadsheet

This is driving me crazy. I have searched the web for an answer, without success. All results are simple pointers on how to use the formatting on the sheets. This misalignment seems to be something ...
0
votes
1answer
124 views

How to reference a cell while keeping its color formatting?

Is it possible to reference a cell which contains "ABC" where B is blue and C is yellow while keeping the color formatting? Assume A1 contains the colored text, then I want B1 to refer to A1 and ...
0
votes
2answers
261 views

Typing in a particular cell and convert it in upper case [closed]

After I typed in a cell a text value (this is in lower case), what do I need to do (after typed it), to become it as the upper case? How do you change the case to upper case for a whole column in ...
0
votes
2answers
3k views

Display only last 4 digits in Google Sheets

I have an eight-digit number (20150613), I just want to display the last 4 digits like 0613. I know I can use a formula like =right(20150613,4), but I don't want to do that; I need the number to stay ...
0
votes
1answer
1k views

How to paste to text editor from Google Docs without it doubling the line breaks between paragraphs?

About 3 weeks ago I began to have this problem occur whenever I copy text from a Google Docs document in Chrome browser and paste it into a text editor. (Technically it's a plain text field within ...
0
votes
1answer
2k views

How to change the default font & font size in Google Documents? [duplicate]

I really hate Arial, which happens to be the default for Google Docs. Does anyone know if there is a way to change the default font and font size in Google Docs? Thanks.
-1
votes
1answer
29 views

How to change formula output directly?

I have a formula which produces some text, how do I highlight a part of the text to change the part's color?
-1
votes
1answer
1k views

How to format a negative number red within a mixed formula result

We use the following formula: ="Stu/W: " & TEXT((A$2/B2),"[Red]#,###,##0.00") &"€" and wish to have the resulting negative currency numbers colored red and positive blue. Unfortunately ...
-2
votes
1answer
76 views

Why does my google calendar look ok on my computer but all the details change to code on my iphone?

I create events on my laptop but when I view them on iPhone all the text in the description section turns to code. I have figured out to not cut and paste, but even if I type in the details it changes ...
-5
votes
1answer
53 views

How do I apply text effects like this in “The Three Evils” [closed]

I know there's an online utility that does it but I can't seem to find it. All my Googling has been in vain. The T̜͓̞̤͎ͦ́ͤ̓̄̚ḣ͖͙̘ͦͯ̾re͗̈́e ̙̥̘̙͉̺̜̐ͧ̍E͍̲̜͈͊v̹͙̝̗ils is the only example I could find of ...

1
2