Extract values between <>

[petar256]

Hi all

Need some help

How can I extract values between <>

Example:

<15.000,00kn 40,00kn>

I need to extract 15.000,00 and 40,00 to a variable1(15.000,00) and variable2(40,00)

Thank you

[Arkadi]

Is the source of the string a cell? A value assigned to a variable in VBA?
Is there always a space between the 2 values?
Details, and a set of data more representative of different situations would really help here.
Also, is the source string bigger or does it start with < and end with >

[Glenn Kennedy]

One way:

=TRIM(MID(SUBSTITUTE("¦"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A1,"<",""),">","")," ","¦"),"¦",REPT(" ",125)),125*COLUMNS($A:A),125))

[Glenn Kennedy]

Copy formula across and down... though I have just seen that this was in the VBA sub-forum

[Arkadi]

A vba option:

Please Login or Register  to view this content.

[petar256]

Is the source of the string a cell? A value assigned to a variable in VBA?
Is there always a space between the 2 values?
Details, and a set of data more representative of different situations would really help here.
Also, is the source string bigger or does it start with < and end with >

All is always the same except the values....

[Arkadi]

Does my code or Glenn's formula solve your issue then?

[jindon]

Just in case

Please Login or Register  to view this content.