Google Sheets contains several functions to help you manipulate data in cells and entire columns. In this video, author Jess Stratton illustrates several methods to parse out first and last names in multiple columns and other text tricks.
- [Instructor] A very common spreadsheet frustration…is when you're exporting contact information…to import it into another contact application…and the first name and last name fields are different.…One app may export it as two separate columns,…first name and last name,…and one contact app may need them as one field,…just a name that contains the first name and last name.…You can fix these issues programmatically,…and I'm gonna show you how.…Let's start by bringing these together as one name.…We have our first name and last name columns…and I've already created a new column header…that says name.…
So now let's enter our formula…to bring it together in one column.…We're going to do that…by bringing them together by concatenating them,…and we do that with the ampersand character.…I'm going to start by adding an equals sign,…which tells Google Sheets that a formula is coming.…I want the contains of cell A2,…and once I type it in, it's going to highlight the cell…so I can make sure I'm working on the right one.…And then I'm going to need a space.…
- Explain why it is beneficial to use a template spreadsheet in Google Sheets rather than start from scratch.
- Name the action you would need to take to make data fit in a column on a Google sheet.
- List the steps to include multiple lines in a cell.
- Explain how to use the iframe code for a chart when publishing it to a website.
- Recall the main advantage of using IFTTT services with Google Sheets.
- Recognize situations where Google Sheets email notifications would be useful.