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.…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Protecting sheets against unwanted changes
- Rearranging rows and columns
- Adding data validation to cells
- Using the image function to easily add images to cells
- Inserting a gauge chart for status updates
- Adding estimate data to Google charts
- Publishing charts to a website
- Using Google Forms to create surveys
- Using Google Sheets add-ons