ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   need function help (https://www.excelbanter.com/excel-worksheet-functions/23048-need-function-help.html)

ChasT

need function help
 
i need a function that takes numbers from a text string seperated by commas,
and places them into seperate cells across a row.


Jason Morin

Select your column of data and go to Data Text to columns. Use comma as
your delimiter.

HTH
Jason
Atlanta, GA

"ChasT" wrote:

i need a function that takes numbers from a text string seperated by commas,
and places them into seperate cells across a row.


ChasT

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 Morin" wrote:

Select your column of data and go to Data Text to columns. Use comma as
your delimiter.

HTH
Jason
Atlanta, GA

"ChasT" wrote:

i need a function that takes numbers from a text string seperated by commas,
and places them into seperate cells across a row.



All times are GMT +1. The time now is 08:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com