Extract value from a text string
Try this:
=RIGHT(A1,LEN(A1)-FIND(CHAR(1),SUBSTITUTE(A1,"
",CHAR(1),LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))
This assumes your data is in cell A1.
Let me know if it works.
--
Regards,
PJ
Please rate this post using the vote buttons if it was helpful.
"Dinesh" wrote:
Hi,
I have three slightly three different text string where I want to extract a
proceed value (672707.58) from it. Below are the text strings.
1) XYZ Corp MLA 2799 SCH 053-000 ABC-72494 Proceeds to ABC for - 672707.58
2) XYZ Corp MLA 2799 SCH 053-000 ABC-72494 Proceeds to ABC Inc for 672707.58
3) XYZ Corp MLA 2799 SCH 053-000 ABC-72494 Proceeds to ABC Inc 672707.58
Below is a formual that works only on the first scenerio. For the second and
third text string, I get a "#value" error.
=IF(ISERROR(SEARCH("ABC",C19)),"0",MID(C19,SEARCH( "- ",C19)+1,99)+0)
Thanks,
Dinesh
|