Remove Last n characters from cell in excel

Remove Last n characters from a cell in excel

For Example

A1 = Juhl Lars Mette

We want to trim it as Juhl Lars only

First, we need to identify the number of characters in a text string

=LEN(A1)

Second, how many characters to avoid including space. Here 6

=LEN(A1)-6)

Final Step Answer will be "Juhl Lars"

=LEFT(A1,LEN(A1)-6)