Mid/Len functions
Hi,
It is working for me I copy your data and it works, check if you don't have
and extra space in your text
"Eduardo" wrote:
Hi,
=TRIM(LEFT(MID(O27,FIND(" ",O27)+9,LEN(O27)),FIND(" ",MID(O27,FIND("
",O27)+9,LEN(O27)))-1))
if this helps please click yes, thanks
"momotaro" wrote:
Hi,
Can anyone help me to find out this formula?
Column A1
The company ABCD1237 ID:xxxxxxxxx3 ABCD company
Company abcd1237 ID:xxxxxxxx4 Thankyoucompany
The result I'd like to get is only the ID:xxxxxxxx3. I have a formula but
it only take the first part ID:xxxxxxxxx3 ABCD company. I'd like to get rid
of ABCD company portion as well. Here is my formula.
=MID(O27,FIND(" ",O27)+9,LEN(O27))
Any suggestions? Thank you.
|