Forum Discussion
Solved
remove all other char spaces number from from cell: only the first char after space must remain
hello can anyone advise why this formula i created =LEFT(TRIM(L161),FIND(" ",(L161))-1) results #value! send me email email address removed for privacy reasons
If you have Microsoft 365:
=LET(T, TRIM(L161), IFERROR(TEXTBEFORE(T, " "), T))
Otherwise:
=IFERROR(LEFT(TRIM(L161), FIND(" ", TRIM(L161))-1), TRIM(L161))
this are sample input:
3-1599 SN 0766
VARIOUS
K24.5100.7 S/N 4083/5683/1347
I like the first word only removing others
3-1599 SN 0766
VARIOUS
K24.5100.7 S/N 4083/5683/1347
I like the first word only removing others
If you have Microsoft 365:
=LET(T, TRIM(L161), IFERROR(TEXTBEFORE(T, " "), T))
Otherwise:
=IFERROR(LEFT(TRIM(L161), FIND(" ", TRIM(L161))-1), TRIM(L161))
- Hans, the first one: this formula Works
=LET(T, TRIM(L161), IFERROR(TEXTBEFORE(T, " "), T))
thank you