Formula

[JonyBravo]

Hi
I’ve got dough and I would like to know if someone could help me. I’ve got a cell on a spreadsheet whit following values:

Values
xxxx,1,core3
xxxx,115,core3
Is there any formula to pick only the numbers between the comas not knowing if will be there 1 or 2 or 3 or more numbers.
Example:

Values----------- Formula
xxxx,1,core3----- 1
xxxx,115,core3--- 115

Thanks

 

[unmarkedhelicopter]

You don't say if your first "xxxx" are always 4 characters.
I have assumed they are but if not the formula will require another 2 find elements, you should be able to work that out for yourself given this.

=MID(A2,6,FIND(",",A2,6)-6)

 

[JonyBravo]

unmarkedhelicop you are an ACE.
Thank you very much for your help.
My first "xxxx" is not always 4 charaters but with what you provided for me I could do what I wanted.

 

[unmarkedhelicopter]

To ensure you get the 'best' solution for your problem, you should always include as much information about how your data looks.
So an additional question would be "does it always end in a "core3" ?"
This would make the formula easier as you could say =LEN(A2)-5 to know where your second comma would be.