Monday, November 13, 2017

yogi_Split String In A1 So That String Begins With Fist Instance Each Of Numbers 1 Through 8

Google Spreadsheet   Post  #2284

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Nov-13-2017
question by: Regexextract
https://productforums.google.com/forum/?nomobile=true#!topic/docs/WTAC_6s8tUY;context-place=topicsearchin/docs/authorid$3AAPn2wQc7O4EQsX1gkj1mKYiVqjACnXxOUJfDW9aP6REEoSb26rzIBkrBhpHOgIm3cS21f6-y3rVl%7Csort:date%7Cspell:false
Parse a numbered list string into multiple cells.
I have a string like "1 one 2 two 2 3 three $3 4 four not 3 5 five 500 6 123-456 7 7-7-7 8 808 lucky number" into:

1 one
2 two 2
3 three $3
4 four not 3
5 five 500
6 123-456
7 7-7-7
8 808 lucky number

I was hoping to use transpose with a regexextract but don't know what pattern to use.

Thank you for your help.