New answers tagged spreadsheet
You can use a quite pragmatic approach to reach your goal. Formula =ARRAYFORMULA( SPLIT( // string REGEXREPLACE( A1:A4, // text "[users,<=>compani]", // regular_expression "" // replacement ), " ") ...
Rather a rigmarole but if I explain correctly should work, I suggest testing on a copy: select data (assumed to be ColumnA), Edit, Find and Replace..., Find [a-z]., select Search using regular expressions, Replace all. change Find to < , Replace all. in B1 put =split(a1," ") and copy down to suit. copy B:C to E1 and Edit, Paste Special...., Paste ...
No formulae are needed. Just select the range, Insert, Chart..., select Histogram, Insert. For the sample as above a bin size of 2 will be automatically selected but this can be changed to 1 by right-clicking the chart area, Advanced edit..., entering 1 for Bucket size and Update. Result should look something like:
Top 50 recent answers are included