Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
"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. |
#5
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I get a program error when I download an excel template | Excel Discussion (Misc queries) | |||
html to excel | Excel Discussion (Misc queries) | |||
Merge from Excel to Excel | Excel Discussion (Misc queries) | |||
Shortcut file fails to open | Excel Discussion (Misc queries) | |||
pivotcell object to excel 2000 | Excel Discussion (Misc queries) |