 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / November 2005text modification
i have a series of 5 numbers separated by commas listed in one cell. i would like to extract each number and list them in separate cells. what is the best way to achieve this? thanks  Signaturejohn The easiest way would be to make sure you have the appropriate number of empty columns to the right then use Data, Text to Columns You have *delimited* text, and on the next dialog you would indicate comma as your delimiter. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm > i have a series of 5 numbers separated by commas listed in one cell. i would > like to extract each number and list them in separate cells. what is the best > way to achieve this? thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.