Remove text or numbers from multiple cells

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

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

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!

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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies