John
Reputation: 1
Excel: Delete everything after the first word in every row
I have a list of first names and last names (in a column) in excel. Each row has a first and its corresponding last name. I would like to get only the first names.
ex.
original data: james smith
output: james
Is there a formula for that?
Thanks!
Upvotes: 0
Views: 75
Answers (1)
Related Questions
- Delete everything in a string before the first period in excel
- Excel: Delete words in the beginning and in the end
- How do you delete everything after the second instance of a word in a cell/delete duplicate in a string?
- MS Excel: Delete data in cells before first instance of character
- If a cell ends in a certain word, how do I delete the entire row? VBA
- Delete a character in excel until the first character
- How do I select the first instance of a string and delete the entire row
- Excel: Delete ALL to the right of the right of particular first "character"
- Delete set number of characters following the first character
- Remove everything after certain string in Excel 2010