Home

Remove text or numbers from multiple cells

%3CLINGO-SUB%20id%3D%22lingo-sub-307460%22%20slang%3D%22en-US%22%3ERemove%20text%20or%20numbers%20from%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-307460%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20Excel%20have%20a%20way%20to%20automatically%20remove%20all%20the%20number%20(or%20text)%20elements%20from%20a%20column%20or%20row%20of%20cells%20that%20each%20contain%20both%20elements%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-307460%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-307474%22%20slang%3D%22en-US%22%3ERe%3A%20Remove%20text%20or%20numbers%20from%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-307474%22%20slang%3D%22en-US%22%3E%3CP%3EThat's%20great.%20I%20frequently%20copy%20stuff%20from%20Excel%20into%20Word%20then%20use%20the%20advanced%20F%26amp%3BR%20features%20in%20Word%2C%20like%20%5Ep%20for%20paragraph%20marks%20and%20%5Et%20for%20tab%20marks%20or%20replacing%20spaces%20for%20%5Et%20then%20removing%20multiple%20%5Et%20to%20get%20back%20to%20single%20%5Et%20then%20convert%20the%20remaining%20text%20into%20a%20table%20and%20pop%20it%20back%20into%20Excel.%20It's%20amazing%20how%20inventive%20one%20can%20get.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-307473%22%20slang%3D%22en-US%22%3ERe%3A%20Remove%20text%20or%20numbers%20from%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-307473%22%20slang%3D%22en-US%22%3E%3CP%3EWell%2C%20that%20seemed%20to%20work.%26nbsp%3B%20I%20had%20a%20column%20in%20which%20each%20cell%20had%20a%20number%20followed%20by%20a%20period%2C%20then%20a%20space%20and%20then%20some%20text.%26nbsp%3B%20When%20I%20did%20Find%20%26amp%3B%20Replace%20I%20put%20Find(*.)%20and%20left%20Replace%20blank%20and%20that%20took%20out%20both%20the%20numbers%20and%20the%20periods!%26nbsp%3B%20Good%20suggestion%20-%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-307464%22%20slang%3D%22en-US%22%3ERe%3A%20Remove%20text%20or%20numbers%20from%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-307464%22%20slang%3D%22en-US%22%3E%3CP%3EHave%20you%20tried%20using%20Find%20%26amp%3B%20Replace%20(Ctrl%20%2B%20H)%20but%20leaving%20the%20Replace%20field%20blank%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
FlightSurgeon
New Contributor

Does Excel have a way to automatically remove all the number (or text) elements from a column or row of cells that each contain both elements?

3 Replies
Highlighted

Have you tried using Find & Replace (Ctrl + H) but leaving the Replace field blank?

Highlighted

Well, that seemed to work.  I had a column in which each cell had a number followed by a period, then a space and then some text.  When I did Find & Replace I put Find(*.) and left Replace blank and that took out both the numbers and the periods!  Good suggestion - Thanks!

Highlighted

That's great. I frequently copy stuff from Excel into Word then use the advanced F&R features in Word, like ^p for paragraph marks and ^t for tab marks or replacing spaces for ^t then removing multiple ^t to get back to single ^t then convert the remaining text into a table and pop it back into Excel. It's amazing how inventive one can get.