 |
 | 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 / New Users / September 2006Trying to delete info in a cell
I have 1 column of information with over a thousand rows of info. I want to just delete some info in the cell and keep the rest. Anyone have any idea how to do this? Here's an example of my info: AABERG 0.000 83.839 38738 AADLAND 0.000 87.245 58868 AAGAARD 0.000 85.690 48524 I want to delete all the numbers. Ay help woud be greatly appreciated. ASAP Utilities, a free Add-in available at www.asap-utilities.com has a built in feature that will strip out all numerical characters from a string. hth Vaya con Dios, Chuck, CABGx3 > I have 1 column of information with over a thousand rows of info. I want to > just delete some info in the cell and keep the rest. Anyone have any idea how [quoted text clipped - 5 lines] > > I want to delete all the numbers. Ay help woud be greatly appreciated. Try Data>Text to Columns then delete the columns you don't need. > I have 1 column of information with over a thousand rows of info. I want to > just delete some info in the cell and keep the rest. Anyone have any idea how [quoted text clipped - 5 lines] > > I want to delete all the numbers. Ay help woud be greatly appreciated. That last suggestion was right on the money! Thanks!! > Try Data>Text to Columns then delete the columns you don't need. > [quoted text clipped - 7 lines] > > > > I want to delete all the numbers. Ay help woud be greatly appreciated. Hello. I am new at excel to but try hitting f2 to edit the cell and do the standard select functions and delete functions. hit enter and you are done. I hope that is accurate. >I have 1 column of information with over a thousand rows of info. I want to > just delete some info in the cell and keep the rest. Anyone have any idea [quoted text clipped - 6 lines] > > I want to delete all the numbers. Ay help woud be greatly appreciated. Select the column and Data>Text to Columns>Delimited by>Space>Next. Select the columns to Skip, which would be all but the letters, and Finish. Gord Dibben MS Excel MVP >I have 1 column of information with over a thousand rows of info. I want to >just delete some info in the cell and keep the rest. Anyone have any idea how [quoted text clipped - 5 lines] > >I want to delete all the numbers. Ay help woud be greatly appreciated. |
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
|
©2008 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.