Thread: Extract specific value from a long text string
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Extract specific value from a long text string
One try ..
Assuming data in A1 down
In B1, copied down:
=MID(A1,SEARCH("- ",A1)+1,99)+0
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dinesh" wrote:
Hi,

I like to extract a value at the end of text string. The long text string
ends with "Inc. for - 356989.23".

Is there a formula where I can just extract the value of "356989.23"
only.The values can in hundreds, thousands, millions, but there is always a
space between a hyphen and where the value start.

Thanks

Dinesh
Reply With QuoteReply With Quote