CALC : Extract first word from a sentence.
Solved
jeanochev
Posted messages
123
Registration date
Status
Membre
Last intervention
-
jeanochev Posted messages 123 Registration date Status Membre Last intervention -
jeanochev Posted messages 123 Registration date Status Membre Last intervention -
Hello,
In the example sentence from a list of definitions, "QUITUS n.m. Dr. Acte de reconnaissance d'une bonne gestion.", how can I extract the first word regardless of the number of letters in the word, that is to say, up to the space?
I simply want to pull out the defined word in the left column.
Thank you for your solution
4 réponses
Hello
If your string of words is in A1
Formula to put in the cell where you want the result
=LEFT(A1,FIND(" ",A1)-1)
Best regards
Good evening,
Thank you, it works.
I would appreciate an explanation for " " and -1 that would help me understand how it works.
Best regards.
Hello.
- " ", that's the space you're talking about here: how to extract the first word regardless of the number of letters in the word, that is to say up to the space?
- The FIND function, if you have looked carefully at its syntax in Excel Help, returns the position of the first character of the searched word. In your example, the space is in the seventh position; therefore, the LEFT function must extract the first 6 characters of the definition.
If you only used the formula =LEFT(A1;FIND(" ";A1) ), you would get {QUITUS } instead of {QUITUS} !
Retirement is great! Especially in the Antilles...
Raymond (INSA, AFPA)