I'm currently updating an excel spread sheet and need to take out a word in each row. The problem is I have over a thousand rows and need to keep some figures in those same rows im editing. At the moment i'm editing it manually, is there a quicker way????
2006-10-10 00:06:37 · 6 answers · asked by K-9 3 in Computers & Internet ➔ Programming & Design
Should be a Find / Replace function... but if you need to keep some then your have to click Find next and then delete and so on and so on...
2006-10-10 00:08:55 · answer #1 · answered by r s 2 · 2⤊ 1⤋
Find and Replace under the edit menu
2006-10-10 00:08:13 · answer #2 · answered by Asher 3 · 1⤊ 0⤋
-Data | Text to Columns...
-Choose Fixed Width
-Click Next
-Set break at 3 character (or 4 if there really is a space)
-Make sure to remove all other breaks
-Click Next
-Select the first column (if not already selected) and choose 'Do Not Import Column (skip)'
-Click Finish
2006-10-10 08:55:03 · answer #3 · answered by O Caçador 6 · 0⤊ 0⤋
Using find and replace you can do it easily. Put the word in the find box and leave the replace box empty.
2006-10-10 00:19:15 · answer #4 · answered by Subbu S 1 · 0⤊ 0⤋
R S answered the question perfectly.
Go with that one.
See ye
2006-10-10 11:14:06 · answer #5 · answered by RAZOR 2 · 0⤊ 0⤋
=SUBSTITUTE(CELLWITHETEXT,"OLDTEXT","NEWTEXT"
=SUBSTITUTE(A9,"BLUE","BLACK")
THIS WILL TAKE OUT THE WORD BLUE AND ADD THE WORD BLACK. IF YOU WANT TO JUST TAKE IT OUT INSTEAD OF "BLACK" JUST DO ""
DO THAT IN ONE CELL, THEN DRAG THE FORMUAL DOWN FOR EACH ROW. SEND ME AN EMAIL OR IM IF YOU ARE STUCK
2006-10-10 00:10:41 · answer #6 · answered by f1avor_f1av 3 · 0⤊ 0⤋