Extracting from a text string

[AmyTaylor]

Hello everyone
Hope someone can help with this question....

I have a field containing a text string, for exampe: "1 : 1.3".
I want to be able to extract the 1.3 and show it in a separate column using a function. Is this possible ?

The characters before the " : " can be any string length, but following the ":" the number I want to extract is always 2 places behind the " : ".
Does this make sense ?
Hope it does, and thanks for your help !
Amy xx

[BenjieLop]

Hello everyone
Hope someone can help with this question....

I have a field containing a text string, for exampe: "1 : 1.3".
I want to be able to extract the 1.3 and show it in a separate column using a function. Is this possible ?

The characters before the " : " can be any string length, but following the ":" the number I want to extract is always 2 places behind the " : ".
Does this make sense ?
Hope it does, and thanks for your help !
Amy xx

Assuming your text is entered in Cell A1, your formula is

=mid(A1,find(":",A1)+1,255)


Regards.

[AmyTaylor]

Hey, thanks for your reply, many thanks - it works perfectly.

Amy xx

[BenjieLop]

Thank you for the feedback ... just glad that I can help.

Regards.