About 1,685,600 results (1,897 milliseconds)
Split text, remove duplicates, or trim whitespace - Computer - Google ...
https://support.google.com/docs/answer/6325535?hl=en&co=GENIE.Platform%3DDesktop You can split clearly defined data, like text separated by commas, into several columns with Google Sheets. For example, a column with "Last name, First name" ...
Split Text with more than one space - Google Docs Editors Community
https://support.google.com/docs/thread/225012971/split-text-with-more-than-one-space?hl=en Jul 10, 2023 ... I have a column of names I want split so the First name and Last name (and any other information) are in just TWO columns. So, in other words, there is more ...
Requesting help with array formula to extract first and last name and ...
https://support.google.com/docs/thread/236672825/requesting-help-with-array-formula-to-extract-first-and-last-name-and-ignore-blank-rows?hl=en Sep 26, 2023 ... I tried using this formula but throws a Value error message. Can someone help? Thanks! Formula: ={"First Name";ArrayFormula(SPLIT(A2:A ...
Formula to pull first word from text string in a column
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/6mpla5aAVFU Jan 8, 2009 ... I have it all working but the last name will duplicate the first if it is a one word name. :( ... split using a space character (" ") using the ...
Send personalized emails with mail merge - Gmail Help
https://support.google.com/mail/answer/12921167?hl=en Email; First name; Last name (optional). Click Finish. Your spreadsheet is added to the "To:" line in the message ...
What would be the best way to custom filter info in a generated sheet ...
https://support.google.com/docs/thread/93134424/what-would-be-the-best-way-to-custom-filter-info-in-a-generated-sheet-that-has-merged-rows?hl=en Jan 12, 2021 ... ... separate sections for each person with a block for in progress and complete training. ... There's also a space between the first name and their ...
Tips to format & clean up data - Google Workspace Learning Center
https://support.google.com/a/users/answer/9604139?hl=en You can split clearly defined data, such as text separated by commas, into separate columns in Sheets. For example, a single column with Last name, First name ...
Is it possible to combine (merge) two columns in a google sheet ...
https://support.google.com/docs/thread/33449662/is-it-possible-to-combine-merge-two-columns-in-a-google-sheet?hl=en Mar 13, 2020 ... ... use Excel since I really don't have any need for it normally. But I ... I tried to go a step further and combine Last Name and first name.
organizing columns in sheets - Google Docs Editors Community
https://support.google.com/docs/thread/29314027/organizing-columns-in-sheets?hl=en Feb 20, 2020 ... I am able to separate the name by using Split Text - Spaces, but can't figure out the other information. When first tried it, I had 6 or 7 ...
Importing contacts from Excel (csv) into Google Contacts not working ...
https://support.google.com/mail/thread/12329488/importing-contacts-from-excel-csv-into-google-contacts-not-working?hl=en Aug 19, 2019 ... ... First Name,Last Name,Email" and the rest of the lines were the person's first, last, and email address copied from a spreadsheet. Google ...
Extract Numbers & Text From Strings With Different Formats ...
https://support.google.com/docs/thread/186339358/extract-numbers-text-from-strings-with-different-formats?hl=en Oct 29, 2022 ... ... using is extracting the first and last categories & rankings. It ... The first one is in the header name Cat. This formula extracts the ...
How can I merge two cells in Sheets and keep contents of both cells ...
https://support.google.com/docs/thread/52208798/how-can-i-merge-two-cells-in-sheets-and-keep-contents-of-both-cells-with-a-comma-in-between?hl=en Jun 8, 2020 ... ... with a comma in between? I have a Google Sheet with data imported from Forms. It lists names in two separate columns (last and first). I ...
How to show partial last value in vlookup when theres multiple ...
https://support.google.com/docs/thread/5337511/how-to-show-partial-last-value-in-vlookup-when-theres-multiple-results-plus-partial-text?hl=en May 2, 2019 ... This does rely on all of your data being consistent with space before the postcode and no duplicate names. ... names have first and second name.
My concatenate with space is not working - Google Docs Editors ...
https://support.google.com/docs/thread/187124903/my-concatenate-with-space-is-not-working?hl=en Nov 4, 2022 ... Suppose I had first name ... I want to join in a single column name and last name - currently in 2 separate columns- with a space between them.
Student's quiz assignment shown as Turned In, but it shows no ...
https://support.google.com/edu/classroom/thread/40070737/student-s-quiz-assignment-shown-as-turned-in-but-it-shows-no-recorded-response-in-the-google-form?hl=en Apr 14, 2020 ... ... for each question. I made sure to collect students' emails, limit to 1 response, and added a question where they type their first and last name.
First Name, Last Name First Letter Extract - Google Docs Editors ...
https://support.google.com/docs/thread/117881155/first-name-last-name-first-letter-extract?hl=en Jul 20, 2021 ... I have tried several methods and I am not able to get the right formula. Kindly help on this. The Sample Sheet is attached here with for ...
Text expressions - AppSheet Help
https://support.google.com/appsheet/answer/10108184?hl=en Constructing a textual value with concatenation · CONCATENATE("ABC", "123") gives ABC123 . · CONCATENATE("Hi, ", [First Name], " ", [Last Name], "!") might give ...
Pull data results from drop down action - Google Docs Editors ...
https://support.google.com/docs/thread/2632603/pull-data-results-from-drop-down-action?hl=en Mar 18, 2019 ... ...and I have this formula joining the first and last names in A1... ... It is basically split the Cell with name and search for the name.
SheetsIQ Tools - Google Workspace Marketplace
https://workspace.google.com/marketplace/app/sheetsiq_tools/819789387468 Dec 5, 2023 ... ... first spreadsheet based on findings from the second spreadsheet. You ... First name, Last name, Middle name, Title, and Suffix. Split ...
How to remove unwanted spaces - Google Docs Editors Community
https://support.google.com/docs/thread/188915830/how-to-remove-unwanted-spaces?hl=en Nov 16, 2022 ... I can copy a string of characters from a PDF and paste them in a cell in my google sheet, but it randomly inserts spaces between the ...