FG
💻 Software

How to return everything between two characters in Excel?

Fresh6 days ago
Mar 15, 202615967 views
Confidence Score0%
0%

Problem

I'm a programmer with lots of languages, but somehow I've never learned Excel macro or formula language. I'm sure there must be a simple way to do this, but I'm stumped. I have a column of file names that look like this: What I need to do is return just the file name, split into several parts based…

Error Output

/home/www/shoppermarketexpo/dot/uploads/10DOT_33A_1275_1308304857_1.jpg
/home/www/shoppermarketexpo/dot/uploads/10DOT_15G_1184_1.jpg
/home/www/shoppe…

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: How to return everything between two characters in Excel?

Low Risk

And here's a VBA based solution. Note, looping through cells like this is not very efficient. If you have a lot of rows (say more than a few 10,000's), there are better ways Select the range you want to process and run this

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment