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

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

"Eric" wrote in message
...
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,2 55),";",
REPT(" ",255)),255),",",".")

If this post helps click Yes
---------------
Jacob Skaria


"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

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