Bit of a long one, but here a formula that extracts the value between first
semicolon and second, and converts the comma to decimal point:

=VALUE(SUBSTITUTE(MID(A1,FIND(";",A1)+1,FIND(";",A 1,FIND(";",A1)+1)-FIND(";",A1)-1),",","."))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Eric" wrote:

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