قالب وردپرس درنا توس
Home / Tips and Tricks / How to Share Text in Google Sheets

How to Share Text in Google Sheets

  Split Text Hero

Often, you must divide the contents of a cell in your spreadsheet, separated by a comma or a space, such as a space. For example, the first and last name of a contact. Fortunately, Google Sheets provides a simple and straightforward approach to dealing with merged records.

Splitting Text into Google Sheets

Start your browser, open a Google Sheets document, and select all the cells you want to share up.

  Select the cells you want to divide ,

Warning: Make sure the cells on the right do not contain any data. This feature overwrites these cells without warning.

Then click Data> Split text into columns.

 Click Data> Split text into columns. "Width =" 342 "height =" 515 "src =" /pagespeed_static/1.JiBnMqyl6S.gif "onload =" pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this); "onerror =" this.onerror = null; pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon Options from which you can select when splitting data in your document, such as: By comma, semicolon, period and space. In this example, "space" is used as the delimiter because there is a space between our datasets. </p>
<p>  <strong> RELATED: </strong> <strong><em>  Automating Google Sheets with Macros </em> </strong> </p>
<p>  Click the drop-down menu and select "spaces" from the list of delimiter options. </p><div><script async src=

 Click the drop-down menu and select Space from the list provided.

The data is immediately separated and stored in the column n next to the original.

 Sheets immediately separates the data into cells on the right.

Do not worry if your data is not separated by the specified options. The Custom option allows you to specify any character.

If you select a delimiter from the drop-down menu, select "Custom" instead.

 Select Custom from the drop-down menu if your data is separated by an uncommon character

Then enter the characters you want to separate in your records into the provided text box.

 Enter the character and Sheets automatically filters it out.

* A disadvantage of this method is the inability to separate data if they contain two different characters. To do this, you'll need to use the Sheet built-in SPLIT function, which we will discuss below.

Voila! The custom delimiter has removed all "@" instances in your cells.

 Even unlisted special characters can be removed from your data.

How to Split Text with the Split Function

While using the previous function allows you to specify only an exact delimiter. You can use the SPLIT function to specify any number of delimiters for a record. For example, suppose your data is an e-mail address and you want to extract the user name, subdomain, and top-level domain in three columns.

Select an empty cell and enter = SPLIT [19659028] ( G14 "@" ) where "G14" is the start cell. Press Enter.

 Click an empty cell and enter = SPLIT (cell_with_data,

. By default, each character of the delimiter is considered in quotation marks, unlike the previous method. Click in the string to "@" and return an unchanged record.

RELATED: The Best Add-ons for Google Sheets

Double-click this feature to apply to the blue square on the remaining cells.

 Double-click the blue square to apply the formal to the rest of the cells.

The function does its magic and removes the separator from Your data.

 Voila! As if by magic, the email addresses are separated.

Now you can use the splitting power of Google Sheets to move your data to different cells in your B rowser to separate spreadsheet.

Source link