Forum Discussion
DAM_ELK
Nov 13, 2023Copper Contributor
Extracting part of a text string
I'm trying to extract a discrete part of a text string -- a number before a certain delimiter, in this case, "%". The string is all text except the number(s) that precede the percentage sign. I want...
OliverScheurich
Nov 13, 2023Gold Contributor
=TEXTAFTER(TEXTBEFORE(A1,"%")," ",LEN(TEXTBEFORE(A1,"%"))-LEN(SUBSTITUTE(TEXTBEFORE(A1,"%")," ","")))
This formula returns the intended result in my sheet.
DAM_ELK
Nov 13, 2023Copper Contributor
This works, thank you!!