Introducing 15 new Zoho Sheet functions

Introducing 15 new Zoho Sheet functions

Zoho Sheet supports more than 350 predefined functions across a wide range of categories, like Text, Financial, and Spreadsheet. We released the LAMBDA function in 2021. Now, we are adding more LAMBDA functions, along with some highly convenient text and spreadsheet functions. Read more about these functions below.
 

Text functions 

ARRAYTOTEXT()

This function allows you to combine values from a range of cells into a single array of text values separated by ";" for columns and "|" for rows. You can choose to display them as simple text or as an array inside the cell.
 
Try it out with the embedded range below!



TEXTSPLIT()

Using this function, you can split a text string into multiple rows and columns with your desired delimiters. While the SPLIT() function helps you split text into adjacent cells in a row, TEXTSPLIT() can be used for splitting text into adjacent cells in a column as well.
 
Try it out with the embedded range below!


 

TEXTAFTER() and TEXTBEFORE()

Use these functions to retrieve part of any text string with your desired characters as the delimiters. For example, you can use the TEXTBEFORE() function to extract the user names from email addresses with @ as the delimiter.
 
Try it out with the embedded range below!

 
 

Spreadsheet functions 

CHOOSEROWS() and CHOOSECOLS()

Still copy-pasting rows/columns from one table to another? Quickly locate and retrieve any desired rows or columns from your data set using these two functions.
 
Try it out with the embedded range below!





WRAPCOLS() and WRAPROWS()

Here's another way to avoid manually copy-pasting values to restructure a data table. Quickly arrange any set/range of values into an ordered array either by column or by row.
 
Try it out with the embedded range below!



EXPAND()

Resize data tables without losing any values using the EXPAND() function. Not a fan of error values occupying the extra cells in your array? Simply fill in your desired value.
 
Try it out with the embedded range below!


 

LAMBDA functions 

We have added six new LAMBDA functions to help you perform customized calculations within your spreadsheets.
 
  • MAP()
  • REDUCE()
  • SCAN()
  • MAKEARRAY()
  • BYROW()
  • BYCOL()
 
Click here to learn more about the new LAMBDA functions.
 
Let us know which functions you're looking forward to using in your spreadsheets in the comment section.


Join the Zoho Sheet community and stay updated on the latest features, interact with fellow users, and learn from the team behind Zoho Sheet.









                        Zoho Marketing Automation
                          Zoho SalesIQ Resources

                                • Sticky Posts

                                • Dark mode in Zoho Sheet—Work with comfort, night or day

                                  With working from home becoming more and more common this last year, we at Zoho Sheet understand that conventional working hours for many people across the globe have changed. That's why we're pleased to say we're making it easier for our users to work

                                • Check out the new Checkbox in Zoho Sheet

                                  Checkbox, the simple GUI widget that lets you choose between two mutually exclusive options i.e Yes or No, is now in Zoho Sheet. Having made it across the web, Checkbox is familiar but is still elusive to most spreadsheet software. Special developer ribbons, macros and all other complexities to add a checkbox to a spreadsheet? Not in Zoho Sheet. How to add Checkbox to Zoho Sheet? Adding a Checkbox in Zoho Sheet is simple. Select a cell/range and choose "Checkbox" in "Input Controls" under the Format

                                • Work seamlessly with Sheet's shortcuts without affecting the browser

                                  Navigating your worksheets and performing specific actions should be a quick and easy process. That's where keyboard shortcuts come in. Shortcut keys help you accomplish tasks more efficiently, eliminating the need to move away from the keyboard. What

                                • New Toolbar in Zoho Sheet

                                  We have revamped our toolbar design in this new version of Zoho Sheet. Below are some screenshots to help you get accustomed to this new interface. Click on the picture below to view the animated image in its original size. Scroll down this post to learn about the changes. Highlight of Changes: The previous format tab is now split into 2 tabs - Home and Format. The Home tab contains the commonly used functions and the Format tab holds formatting related options. Under the Home tab towards the far

                                • Introducing 15 new Zoho Sheet functions

                                  Zoho Sheet supports more than 350 predefined functions across a wide range of categories, like Text, Financial, and Spreadsheet. We released the LAMBDA function in 2021. Now, we are adding more LAMBDA functions, along with some highly convenient text


                                Manage your brands on social media
                                Access Zoho Social

                                  Zoho Pagesense Resources


                                        Zoho TeamInbox Resources

                                          Zoho DataPrep Resources



                                            Zoho CRM Plus Resources

                                              Zoho Books Resources


                                                Zoho Subscriptions Resources

                                                  Zoho Desk Resources

                                                    Zoho Projects Resources


                                                      Zoho Sprints Resources


                                                        Qntrl Resources


                                                          Zoho Creator Resources


                                                            Zoho WorkDrive Resources



                                                              Zoho Campaigns Resources

                                                                Zoho CRM Resources

                                                                • CRM Community Learning Series

                                                                  CRM Community Learning Series


                                                                • Tips

                                                                  Tips

                                                                • Functions

                                                                  Functions

                                                                • Meetups

                                                                  Meetups

                                                                • Kbase

                                                                  Kbase

                                                                • Resources

                                                                  Resources

                                                                • Digest

                                                                  Digest

                                                                • CRM Marketplace

                                                                  CRM Marketplace

                                                                • MVP Corner

                                                                  MVP Corner

                                                                • Word of the Day

                                                                  Word of the Day


                                                                        Design. Discuss. Deliver.

                                                                        Create visually engaging stories with Zoho Show.

                                                                        Get Started Now