SUBSTITUTE multiple numbers in one formula

Sufiyan97

Well-known Member
Joined
Apr 12, 2019
Messages
1,538
Office Version
  1. 365
  2. 2013
Platform
  1. Windows
Is there any way using formula only to remove numbers from text string

I can use multiple SUBSTITUE to remove numbers from 0 to 9 but looking for shorter formula

All Invoice Names List.xlsx
H
3
4Trend Invoice_78150_1625054805218
5Sunrise Pool Care sqinv-UPSTAY-4106
6Richer Logic Invoice 1064
7RGM 2028
8Quality Mountain Services 6514
9Pro Service Blue - invoice - 07-15-2021 to 07-31-2021
10NoiseAware LLC Invoice-D43CF183-0005
11MongoDB Atlas Invoice - 2021-08-01 - upstay
12MongoDB Atlas Invoice - 2021-07-01 - upstay
13Massey 2016_001
Sheet1
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Have a look here: How to remove text or numbers from Excel cell

If you do not have Excel 365 or 2019, then there does not appear to be a real good formula option that is not a bit long/cumbersome.
But there are VBA options which are pretty concise.
 
Upvote 0
Have a look here: How to remove text or numbers from Excel cell

If you do not have Excel 365 or 2019, then there does not appear to be a real good formula option that is not a bit long/cumbersome.
But there are VBA options which are pretty concise.
Yes, you are correct.
I don't want to go for VBA I will manage with longer SUBSTITUTE formula
 
Upvote 0

Forum statistics

Threads
1,215,026
Messages
6,122,738
Members
449,094
Latest member
dsharae57

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top