With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Tuesday, December 27, 2016
yogi_Array Formula For Splitting Row By Row Entries In Column A Of Sheet 'T1 Cores'
REGEXTRACT() function to split data in an array stopped working
I've been using the function string =TRANSPOSE(ARRAYFORMULA(IFERROR(REGEXEXTRACT(" "&'T1 Cores'!S2:S26,"^"&REPT(" +[^ ]+",COLUMN(OFFSET(A1,,,1,25))-1)&" +([^ ]+)")))) for some time now to split data separated by spaces in cells in the range 'T1 Cores'!S2:S26 and it has stopped working properly now. All that is displayed is the first item in each of the cells in that range and nothing after the first space. Using the SPLIT() function with space as the delimiter works fine, but I have a large range of changing data so it's not practical to use SPLIT() since it can't be used in an array.