 |
 | 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 / February 2008Delete part of a cell
I have a spreadsheet with 10,000 rows with this information; Rows look like this, R1 Ontime: 100.00% R2 711 *OEM1676EN R3 Tot R4 Ontime: 92.00% R5 129 D317002 I need to find all rows that contain "Ontime:" and remove the word "Ontime:" to leave the percentage in that cell only. This is all in one column. Or, can I just copy the percentage part to another cell? Please help try selecting the column header>edit>replace>Ontime:, leave blank  SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com >I have a spreadsheet with 10,000 rows with this information; > Rows look like this, [quoted text clipped - 11 lines] > I just copy the percentage part to another cell? > Please help Data > TextToColumns > using a colon as the delimiter, will place the percentages in the next column to the right...........if that's a help Vaya con Dios, Chuck, CABGx3 > I have a spreadsheet with 10,000 rows with this information; > Rows look like this, [quoted text clipped - 9 lines] > I just copy the percentage part to another cell? > Please help Select the cells and then: Edit > Replace replacewhat: Ontime: leave replacewith blank SignatureGary''s Student - gsnu200767 > I have a spreadsheet with 10,000 rows with this information; > Rows look like this, [quoted text clipped - 9 lines] > I just copy the percentage part to another cell? > Please help that worked, thank you very much > Select the cells and then: > [quoted text clipped - 15 lines] > > I just copy the percentage part to another cell? > > Please help You may like this even better Sub replacewords() Set rng = Range("d8:d12") rng.Replace "Ontime:", "" For Each c In rng c.Value = Right(c, Len(c) - 3) Next End Sub SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com >I have a spreadsheet with 10,000 rows with this information; > Rows look like this, [quoted text clipped - 11 lines] > I just copy the percentage part to another cell? > Please help |
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.