FG

Excel extract substring from string

Fresh3 days ago
Mar 15, 2026192787 views
Confidence Score0%
0%

Problem

I am looking for a way to extract a variable length substring from a string. My cells will look something like: I want to split the string at the character, so the cells will become: This should be done with a formula and not VBScript. I am using Excel 2010 EDIT I found that the dataset doesn't alw…

Error Output

ABC - DEF
ABCDE - DEF
ABCD - ABC

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Excel extract substring from string

Low Risk

This problem can be broken down into two steps: Find the index in the string of your desired split character (in this case, or ). Get the prefix substring from the beginning of the original text to the split index. The and commands each would return…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment