Split text to columns in Google Sheets

Google has introduced a new update to Google Sheets – converting text into columns.

You will no longer need to type in a formula to split your data. To get started, you can select the columns you want to split, and click Data > Split text to columns. A menu will then appear underneath the data, giving you multiple options to split the data such as commas, semicolons, periods, spaces, and even custom separators.

In addition to the β€œSplit text to columns” option, you will see a just-in-time icon appear as soon as you have pasted content into the sheet prompting you to choose if you want to separate your text into multiple columns as shown in the animation below.
Click here to see the Help Center for more information.
Don't Miss a Bit or Byte!

Don't Miss a Bit or Byte!

Sign up to our newsletter for the latest news and tips & tricks from Business Cloud Inc. By providing your information, you consent to receive Business Cloud emails. You may unsubscribe at any time.

Thank you! You have successfully subscribed!