Hi

If Cell A1 Contained 1,154,546,487,47,36,48,47,668 and so on. Using a Formula or Macro how can I get it to take each number(s) before each comma and put it in the next column on the same row?

So using the above example numbers you would end up with 1 in column A1 and 154 in column B2 and so on and so forth.


Thanks