Google Spreadsheet Post #838
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Oct 30, 2012
user david.vlk said: (http://productforums.google.com/forum/?zx=gdxpen6jynp#!mydiscussions/docs/uTsVxJQ5QkU)
remove enter (end of line)
In Spreadsheet column with no line braking set I want to remove enters (end of line) or what is called hidden sign so the line is just one line not more. To put the question simple: how to make a "one line" line out of a line which has more lines when "no line brakes" is on? Example:
Bad
text
text
text
What I want
text text text
I understand that this can be done by manually removing (backspacing for example) spaces at the end of the word on the upper line but how to this automatically in a whole cell? Using delete formatting does not help nor anything else i tried.
Thank you for your suggestions.
-----------------------------------------------------------------------------------------
following is a solution to the problem
No comments:
Post a Comment