How can I trim "4|+|23.68^" into "23.68" in excel 2000?
 

I can not find a solution for it. Please help me. Thank you!
--
George

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,FIN D("^",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: -

"smb2000user100" wrote in message
...

I can not find a solution for it. Please help me. Thank you!
--
George

Thank you very much! The formula solved my problem.

Best regards,

George

"N Harkawat" wrote:

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,FIN D("^",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: -

"smb2000user100" wrote in message
...

I can not find a solution for it. Please help me. Thank you!
--
George

"N Harkawat" wrote...
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.

Thank you! It is a good solution.

Best regards,

George

"Harlan Grove" wrote:

"N Harkawat" wrote...
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.