Take data from cell

[parvizkasimov]

Hey guys, I am new here. But I have an urgent favor to ask from community.

I have a table which has 5-8 numbers in 1 cell separated by the comma. I need a way how to take each piece of number and insert it into another cell.

Any information about the function or other way. Have to make similar adjustments to more than 1000 cells and several columns.

Thank you for help,
Parviz

[Andrew-R]

If it's a one-off operation then just use the text-to-columns function, which is in the data menu (in 2007, at least), specifying a comma as a delimiter.

[parvizkasimov]

Dear Andrew-R

Thank you,

You saved my life. Thank you very much for help. It works perfectly for me!!!