View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default How to retrieve the value?

Does anyone have any suggestions on how to retrieve the first value after the
first ";"? On following example, I would like to retrieve 427,75 value, and
return it into cell B1 427.75.

04.01.2005;427,75;5,8600;2506,62;104,27;44601,49;1 ,3295;321,74

Does anyone have any suggestions on how to do it in Excel?
Thanks in advance for any suggestions
Eric