G Guest Apr 21, 2005 #1 i need a function that takes numbers from a text string seperated by commas, and places them into seperate cells across a row.
i need a function that takes numbers from a text string seperated by commas, and places them into seperate cells across a row.
G Guest Apr 21, 2005 #2 Select your column of data and go to Data > Text to columns. Use comma as your delimiter. HTH Jason Atlanta, GA
Select your column of data and go to Data > Text to columns. Use comma as your delimiter. HTH Jason Atlanta, GA
G Guest Apr 21, 2005 #3 jason: wow, that's SUPER. I know this is simple, but you've just saved me several hours of work. thanks a million. ct
jason: wow, that's SUPER. I know this is simple, but you've just saved me several hours of work. thanks a million. ct