yogi_Split A String Consisting Of Several Sets Of Entries Into Their Respective Set In Columns Separated at ZipCode For Each Set

Google Spreadsheet   Post  #2005

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-02-2016

post by: Daniel Gyimah:

https://productforums.google.com/forum/#!topic/docs/BO_crjos6l4;context-place=forum/docs

Split comma delimited text in one cell into multiple columns and rows
Hi,

I have a string of text separated by commas in one cell, for example:

A1: George, Michael, 49Yrs, Musician, 6ft2in, 240lbs, Bos, 01616, Tony, Douglas, 32Yrs, Boxer, 5ft11in, 145lbs, Bal, 21228, Sam, Mitchell, 46Yrs, Accountant, NY, 10475

I want to separate it so it looks like this:

  A B C D E F I J

George Michael 49Yrs Musician 6ft2in 240lbs Bos 01616

Tony Douglas 32Yrs Boxer 5ft11in 145lbs Bal 21228

Is there a function or code I can use to split the text maybe after the 8th comma, and then I can transpose the data into rows?

Anything will help.

Thanks

Daniel

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