how to extract certain info for a cell - between a "," and a ";"?

[JOEODC]

hi!
i have a series of cells with text that looks like this
10,11.13;
5,155.07;
144,.89;
what formula (or formula combinations) can i use to get the info between the "," and the ";" into another cell?
thanks so much for your help!
=)

so for the above 3 cells i would want the
11.13
155.07
.89

 

[Jonmo1]

Welcome to the board

Try
=SUBSTITUTE(REPLACE(A1,1,FIND(",",A1),""),";","")

If you want the resulting text string to be converted to a number, just add+0
=SUBSTITUTE(REPLACE(A1,1,FIND(",",A1),""),";","")+0

 

[VoG]

One way

=SUBSTITUTE(RIGHT(A1,LEN(A1)-FIND(",",A1)),";","")+0

 

[JOEODC]

thanks so much! really appreciate you taking your time to help me out!
have a happy day!

 

[Jonmo1]

Glad to help, thanks for the feedback.

 

[salfordchameleon]

=MID(A1,FIND(",",A1)+1,FIND(";",A1)-FIND(",",A1)-1)

if you number is in cell A1

 

[JOEODC]

thanks soo much for all the help!!!!!

also - im sure this is easy - but what is the easiest way to get the numbers in front of the "," i tried a simple left formula - but the numbers are different digits.
thanks!!!!

 

[salfordchameleon]

=LEFT(A1,FIND(",",A1)-1)

if your number is in cell A1

 

[JOEODC]

thanks!!!!