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.
Does anyone have any idea how I can extract the second and third (104 and 155) set of numbers?![]()
=LEFT(C5,FIND(",",C5)-1)
Appreciate if anyone could assist.
Thanks.
Bookmarks