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    May 15, 2015
question  by Zackary Simkover in

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 -