Google Sheets announced yesterday the free of a novel handy characteristic that allows yous to easily convert text to columns. This is specially helpful when pasting delimited information ( information separated past times commas) inward a spreadsheet. With a unmarried click yous volition bring all your delimited information spread across unlike columns.
To dissever your delimited data, yous merely select the column yous desire to split, click ‘data’ as well as therefore guide ‘Split text to columns’ as well as pick i of the options there. You tin dissever information using commas, periods, spaces, semicolons as well as many other pop separators.
‘In improver to the “Split text to columns” option, yous tin too format cells containing delimited information using a contextual bill of fare that appears straight off later you’ve pasted data, every bit shown inward the animation below. You tin guide a custom separator through this method also’. Check out Google Sheets Help Center to larn more.
Follow us on : Twitter, Facebook , Google plus, Pinterest .
No comments:
Post a Comment