Dec 29 2018 03:03 PM
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?
Dec 29 2018 04:13 PM
Have you tried using Find & Replace (Ctrl + H) but leaving the Replace field blank?
Dec 29 2018 09:23 PM
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!
Dec 29 2018 10:01 PM
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.