How to split texts from dynamic range?

by

Have a go with TEXTSPLIT() nested in REDUCE():

enter image description here

Formula in B1:

=IFERROR(DROP(REDUCE(0,A1:A15,LAMBDA(a,b,VSTACK(a,TEXTSPLIT(b,{"|"," ("})))),1,-1),"")

More Related Contents:

  1. Excel UNIQUE Across Columns
  2. Using UNIQUE with non-adjecent columns on different sheets
  3. Want to concatenate multiple row data in in cell along with its values if present. Emp Id should not come if no data available infromt of it
  4. Calculation is wrong, Rounding wrong
  5. Excel formula checklist in employees
  6. Sequence of numbers based on start and end value of 2 cells [closed]
  7. Excel VBA – How to add dynamic array formula
  8. Return empty cell from formula in Excel
  9. TEXTJOIN for xl2010/xl2013 with criteria
  10. Difference between date and time w/out work week Excel
  11. How can I perform a reverse string search in Excel without using VBA?
  12. Excel Formula for Inventory
  13. Count Unique values with a condition
  14. Count unique values in Excel
  15. Concatenate column headers if value in rows below is non-blank
  16. How do I apply a SumIf Formula in a VBA Sub? Getting Error 1004
  17. Using the value in a cell as a cell reference in a formula?
  18. How to list all possible combinations of the values in three columns in excel?
  19. Excel – extracting top 5 values
  20. CountIf With Filtered Data
  21. How to count cells in a range with a value less than another cell in excel?
  22. Extract the last substring from a cell
  23. How to extract text within a string of text
  24. Excel: How to gather unique values in one column that are associated with duplicates in another column?
  25. excel vlookup with multiple results
  26. How to roundup a number to the closest ten?
  27. Convert an Array Formula’s Text Results into a Usable Format
  28. Can’t pass a range to a lambda using Let and Makearray functions
  29. Unique Rank value for a subgroup within a group
  30. Get content of a cell given the row and column numbers

Leave a Comment