AppsCare | Convert text to columns in Google Sheets more easily - AppsCare
AppsCare is a Google for Work Premier Partner in the UK and specialises in the deployment of Google Apps for Work, Google Drive for Work, Google for Education, Google Maps for Work, Chrome Devices for Work and Google Search.
google enterprise premier partner, google enterprise partner, google enterprise reseller, google apps reseller, google apps partner, google maps reseller, google maps partner, chromebooks reseller, chromebox for meetings, google maps for business, google apps for business, google apps for education, google drive for work, drive for work, google for work, google apps for work, google maps for work, chrome for work, google for work premier partner, google apps for work reseller, uk, google for work uk premier partner, google apps reseller, google apps partner
single,single-post,postid-19270,single-format-standard,ajax_fade,page_not_loaded,,wpb-js-composer js-comp-ver-4.0.5,vc_responsive

03 Mar Convert text to columns in Google Sheets more easily

Google have launched a feature in Google Sheets that allows you to copy and paste data into a spreadsheet smartly into columns. You can now split delimited data from one column to another in several ways, for example, once you select the columns you want to split, click Data > Split text to columns. A menu will then appear underneath the data, allowing you to split the data using commas, semicolons, fullstop, spaces, and custom separators as shown below.


Screen Shot 2016-03-03 at 09.58.48


Screen Shot 2016-03-03 at 12.02.14


In addition to the above option, you can also format cells containing delimited data using a contextual menu that appears immediately after you’ve pasted data, as shown below. You also have the option to use custom separator if you prefer.

Once you have copied and paste the text you would like onto your spreadsheet, select the paste formatting option and choose how you would like to split the data via the separator option. I have chosen to split my data by ‘space’ as shown below.


Screen Shot 2016-03-03 at 12.03.15


Screen Shot 2016-03-03 at 12.05.12


Screen Shot 2016-03-03 at 12.15.14


Screen Shot 2016-03-03 at 10.19.59


Stay tuned for more tips and tricks, until next week.'
Crea ONeill
No Comments

Post A Comment