S
smb2000user100
I can not find a solution for it. Please help me. Thank you!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
N Harkawat
If the number that you want to extract always begins after second instance
of "|" and ends just before "^" then use the following: -
=--(MID(A1,FIND("xx",SUBSTITUTE(A1,"|","xx",2))+1,FIND("^",A1)-(FIND("xx",SUBSTITUTE(A1,"|","xx",2))+1)))
If the number that you want to extract always begins after second instance
of "|" and ends just before "^" then use the following: -
of "|" and ends just before "^" then use the following: -
=--(MID(A1,FIND("xx",SUBSTITUTE(A1,"|","xx",2))+1,FIND("^",A1)-(FIND("xx",SUBSTITUTE(A1,"|","xx",2))+1)))
If the number that you want to extract always begins after second instance
of "|" and ends just before "^" then use the following: -
S
smb2000user100
Thank you very much! The formula solved my problem.
Best regards,
George
Best regards,
George
H
Harlan Grove
....N Harkawat said:If the number that you want to extract always begins after second instance
of "|" and ends just before "^" then use the following: -
If these assumptions hold, better to use Edit > Replace to eliminate the ^s,
then use Data > Text to Columns, Delimited, specify | as the delimiter, and
skip the first two fields.
S
smb2000user100
Thank you! It is a good solution.
Best regards,
George
Best regards,
George