- Jun 10, 2011
- Office Version
I have ton of data In Column A that is looks like 13,165 or 6,300,400,765 the problem is that it is formatted like 13165 and 6300400765 and formatted to a number. I need to parse these numbers based on the commas into separate cells but cannot based on the number format. Can anyone help me with this? Thanks in advance.