View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dinesh Dinesh is offline
external usenet poster
 
Posts: 103
Default Extract specific value from a long text string

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