https://bugs.documentfoundation.org/show_bug.cgi?id=150866
--- Comment #4 from Jeremy Clark <[email protected]> --- (In reply to Óvári from comment #2) > What's new in Office 2024 and Office LTSC 2024 > ============================================== > > https://support.microsoft.com/office/what-s-new-in-office-2024-and-office- > ltsc-2024-baadecbe-a8fc-4435-8cb8-70e93fd08b56 > > > Text and array functions > ------------------------ > > There are now 14 new text and array functions in Excel 2024 that are > designed to help you manipulate text and arrays in your worksheets. These > functions make it easier to extract and split text strings and enable you to > combine, reshape, resize, and select arrays with ease. > > TextBefore() - TEXTBEFORE function > Returns text that’s before delimiting characters > https://support.microsoft.com/office/textbefore-function-d099c28a-dba8-448e- > ac6c-f086d0fa1b29 > > TextAfter() - TEXTAFTER function > Returns text that’s after delimiting characters > https://support.microsoft.com/office/textafter-function-c8db2546-5b51-416a- > 9690-c7e6722e90b4 > > TextSplit() - TEXTSPLIT function > Splits text into rows or columns using delimiters > https://support.microsoft.com/office/textsplit-function-b1ca414e-4c21-4ca0- > b1b7-bdecace8a6e7 > > VStack() - VSTACK function > Stacks arrays vertically > https://support.microsoft.com/office/vstack-function-a4b86897-be0f-48fc-adca- > fcc10d795a9c > > HStack() - HSTACK function > Stacks arrays horizontally > https://support.microsoft.com/office/hstack-function-98c4ab76-10fe-4b4f-8d5f- > af1c125fe8c2 > > ToRow() - TOROW function > Returns the array as one row > https://support.microsoft.com/office/torow-function-b90d0964-a7d9-44b7-816b- > ffa5c2fe2289 > > ToCol() - TOCOL function > Returns the array as one column > https://support.microsoft.com/office/tocol-function-22839d9b-0b55-4fc1-b4e6- > 2761f8f122ed > > WrapRows() - WRAPROWS function > Wraps a row array into a 2D array > https://support.microsoft.com/office/wraprows-function-796825f3-975a-4cee- > 9c84-1bbddf60ade0 > > WrapCols() - WRAPCOLS function > Wraps a column array into a 2D array > https://support.microsoft.com/office/wrapcols-function-d038b05a-57b7-4ee0- > be94-ded0792511e2 > > Take() - TAKE function > Returns rows or columns from array start or end > https://support.microsoft.com/office/take-function-25382ff1-5da1-4f78-ab43- > f33bd2e4e003 > > Drop() - DROP function > Drops rows or columns from array start or end > https://support.microsoft.com/office/drop-function-1cb4e151-9e17-4838-abe5- > 9ba48d8c6a34 > > ChooseRows() - CHOOSEROWS function > Returns the specified rows from an array > https://support.microsoft.com/office/chooserows-function-51ace882-9bab-4a44- > 9625-7274ef7507a3 > > ChooseCols() - CHOOSECOLS function > Returns the specified columns from an array > https://support.microsoft.com/office/choosecols-function-bf117976-2722-4466- > 9b9a-1c01ed9aebff > > Expand() - EXPAND function > Expands an array to the specified dimensions > https://support.microsoft.com/office/expand-function-7433fba5-4ad1-41da-a904- > d5d95808bc38 > > New IMAGE function > ------------------ > > Now in Excel 2024, you can add pictures to your workbooks using copy and > paste or you can use the IMAGE function to pull pictures from the web. You > can also easily move, resize, sort, and filter within an Excel table > without the image moving around. > > Image() - IMAGE function > https://support.microsoft.com/office/image-function-7e112975-5e52-4f2a-b9da- > 1d913d51f5d5 I was happy to see the proposal to add the TEXTSPLIT function to Calc, which would improve compatibility with MS Excel. This would not only improve usability but also make it easier for users to manipulate data. Hopefully the development team will implement this feature soon! -- You are receiving this mail because: You are the assignee for the bug.
