Friday, May 15, 2015

yogi_ From A Two-Line Input Per Cell In A Column Split First_Line And Second_Line Entries Row By Row In Adjacent Columns


                                           Google Spreadsheet   Post  #1958
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    May 15, 2015
question  by Zackary Simkover in 
http://yogi--anand-consulting.blogspot.com/2013/07/yogisplit-row-on-new-line-for-all.html

Hi Yogi,
I'm trying to split based on carriage return (new line), but I want the first line of a cell's data to remain in column A (Name), and everything on the second line in column A moved over to column B (Personal Headline). How could I update your formula from this post to do this? Thanks!

Example of what I'm seeing - 
https://docs.google.com/a/checkmate.io/spreadsheets/d/1u6qQDS2w9pdu7LqPnnfsfYibKo-Ydgq2E3HfHfVpPrY/edit?usp=sharing

-------------------------------------------------------------------------------------------------------------------