https://bugs.documentfoundation.org/show_bug.cgi?id=151001
Óvári <ovari...@zoho.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |ovari...@zoho.com
--- Comment #1 from Óvári <ovari...@zoho.com> ---
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
--
You are receiving this mail because:
You are the assignee for the bug.
