Sufiyan97
Well-known Member
- Joined
- Apr 12, 2019
- Messages
- 1,538
- Office Version
- 365
- 2013
- Platform
- 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
I can use multiple SUBSTITUE to remove numbers from 0 to 9 but looking for shorter formula
All Invoice Names List.xlsx | |||
---|---|---|---|
H | |||
3 | |||
4 | Trend Invoice_78150_1625054805218 | ||
5 | Sunrise Pool Care sqinv-UPSTAY-4106 | ||
6 | Richer Logic Invoice 1064 | ||
7 | RGM 2028 | ||
8 | Quality Mountain Services 6514 | ||
9 | Pro Service Blue - invoice - 07-15-2021 to 07-31-2021 | ||
10 | NoiseAware LLC Invoice-D43CF183-0005 | ||
11 | MongoDB Atlas Invoice - 2021-08-01 - upstay | ||
12 | MongoDB Atlas Invoice - 2021-07-01 - upstay | ||
13 | Massey 2016_001 | ||
Sheet1 |