muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all..
i'm looking for a formula to figure out this problem. How to extract or get last name file without extension in single column, this just my sample
'i,m using Excel 2021 and please, don't use vba
anyone help, greatly appreciated..
susant
i'm looking for a formula to figure out this problem. How to extract or get last name file without extension in single column, this just my sample
Book1 | ||||
---|---|---|---|---|
B | C | |||
2 | data | expeted result | ||
3 | D:\test\xxxxx\abc\a\1wbbm\ND 131.pdf | ND 131 | ||
4 | D:\test\zz\test\a\nd 346 himbauan.jpg | nd 346 himbauan | ||
5 | D:\test\Rekapitulasi.docx | Rekapitulasi | ||
Sheet1 |
'i,m using Excel 2021 and please, don't use vba
anyone help, greatly appreciated..
susant