How to retrieve the value?

  • Thread starter Thread starter Eric
  • Start date Start date
E

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
 
=--SUBSTITUTE(LEFT(SUBSTITUTE(MID(A1,FIND(";",A1)+1,255),";",
REPT(" ",255)),255),",",".")

If this post helps click Yes
 
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),",","."))
 
Back
Top