Extracting Numbers Before and After A Comma

Hi there,

I'm not sure if this is at all possible, but I have a cell column with a collection of numbers. Example : 90,104,155.

I'm trying to figure out a way to extra these numbers into different columns. I only managed to extract the number prior to the first comma "," with the following formula.

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

Does anyone have any idea how I can extract the second and third (104 and 155) set of numbers?

Appreciate if anyone could assist.

Thanks.

Thanks MarvinP, that works very well. Appreciate your help.

Hi MarvinP, I tried your formula on a different spreadsheet this time but it didn't seem to work. Would you by any chance be able to assist me with this?

On my new spreadsheet, A1 now contains a similar data to the one below.

1;"0";"Last Name";"First Name";"my@email.com";"0123456789"

I changed the formula to

=VALUE(TRIM(MID(SUBSTITUTE($A1,";",REPT(" ",LEN($A1))),LEN($A1)*(COLUMN()-2)+COLUMN()-1,LEN($A1))))

while it managed to pick up for the first value "1" but the rest are returning as #VALUE!

Do you happen to know what needs to be changed to have this working?

Appreciate if you could help.

Thanks in advance.