Tuesday, October 30, 2012

yogi_Convert MultiLine Input Within A Cell To A SingleLine Text

                                           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:


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