How to retrieve the value?

[Eric]

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

 

[David Biddulph]

Data/ Text to Columns/ Delimited/ Semi-colon
Skip columns that you don't want.

 

[Jacob Skaria]

=--SUBSTITUTE(LEFT(SUBSTITUTE(MID(A1,FIND(";",A1)+1,255),";",
REPT(" ",255)),255),",",".")

If this post helps click Yes

 

[Luke M]

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(";",A1,FIND(";",A1)+1)-FIND(";",A1)-1),",","."))