Extracting from a text string

A

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 :)
 
B

BenjieLop

AmyTaylor said:
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 :)
Click to expand...

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

=MID(A1,FIND(\":\",A1)+1,255)


Regards.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Extract Text from decimal separated string 6
Extracting certain text from text string 2
Extracting text from string 4
Extracting a numbers from a text string 24
Extracting charecter from a string 3
Extract characters from Right of string 5
Extracting Data from a string of text in a cell 4
Extracting text from text string 3

Top