Home

Remove text with numbers in excel sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-369888%22%20slang%3D%22en-US%22%3ERemove%20text%20with%20numbers%20in%20excel%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-369888%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3BDear%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3Bhope%20all%20are%20good%20in%20health%20I%20have%20some%20issue%20in%20my%20excel%20file.%20I%20want%20to%20remove%20text%20in%20cell%20which%20showing%20with%20numbers%20do%20you%20have%20any%20formula%20so%20kindly%20share%20with%20me.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-369888%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-369945%22%20slang%3D%22en-US%22%3ERe%3A%20Remove%20text%20with%20numbers%20in%20excel%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-369945%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3Eif%20you%20are%20using%20an%20Excel-Version%2C%20which%20knows%20about%20the%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-gb%2Farticle%2Ftextjoin-function-357b449a-ec91-49d0-80c3-0e8fc845691c%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ETEXTJOIN-function%3C%2FA%3E%2C%20you%20can%20try%20%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fformula%2Fstrip-non-numeric-characters%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EExceljet's%20formula%20here%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3EBest%2C%3C%2FP%3E%0A%3CP%3EMourad%3C%2FP%3E%3C%2FLINGO-BODY%3E
M.Yasir Fakhr
Occasional Contributor

 Dear All,

 hope all are good in health I have some issue in my excel file. I want to remove text in cell which showing with numbers do you have any formula so kindly share with me. 

1 Reply

Hi,

if you are using an Excel-Version, which knows about the TEXTJOIN-function , you can try Exceljet's formula here.

Best,

Mourad

Related Conversations
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
Tabs and Dark Mode
cjc2112 in Discussions on
22 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