Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I was working on a Google Spreadsheet and I found that it does not allow more than one white space anywhere.

Is there any option to stop auto trimming on text? I searched it but didn’t found any solution.

╔═══════════════════╦═════════════╗
║ what google gives ║ what I want ║
╠═══════════════════╬═════════════╣
║ text              ║    text     ║
╚═══════════════════╩═════════════╝
share|improve this question
    
Can you share a doc with us and show us the expected outcome? –  Jacob Jan Tuinstra Jun 18 '13 at 7:11
    
@JacobJanTuinstra I just want that when I put spaces in beginning or end of text .. it should not get trimmed off –  Let's Code Jun 18 '13 at 7:18
    
Have a look at this Q&A: webapps.stackexchange.com/q/40297/29140 –  Jacob Jan Tuinstra Jun 18 '13 at 7:20
    
@JacobJanTuinstra please see my edited question –  Let's Code Jun 18 '13 at 7:32
    
@JacobJanTuinstra not working –  Let's Code Jun 18 '13 at 7:37

2 Answers 2

up vote 3 down vote accepted

You can use a formula workaround which should work regardless of the OS, eg:

=CHAR(160)&"text"

=CHAR(160)&CHAR(160)&"text"

=REPT(CHAR(160);3)&"text"

share|improve this answer

I always use the keystrokes "Alt+0160" or "Alt+255" to get it to indent.

You have to be in cell edit mode. Type the keystrokes above for a space. This solves your question "stop auto trimming on text" but your subject says "allow trailing white spaces". With the limited info I would say it works for that too.

This is useful for indenting and such in some formats.

share|improve this answer
    
thanks for your answer .. but I am using fedora os. When I press any number holding alt .. it changes the window .. –  Let's Code Jun 19 '13 at 3:53
    
That being a critical part of your problem, would have been nice to see that in the question. –  William Jun 19 '13 at 14:06

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.