Before and After a Delimiter
Key points
- Enter the delimiter
- See the formula
- Check it
In LEFT/MID Builder you can take the text before or after a delimiter such as - or /.
Steps
- Enter the delimiter
- See the formula
- Check it
FIND is used to locate the delimiter.
Use "Build a LEFT, MID or RIGHT Formula" (free)
Tools that go well with this
- Remove Extra Spaces and Invisible Characters from Excel Text: Remove extra spaces and invisible characters.
- Split Text into Columns by a Delimiter: Split text into columns by a delimiter.
- Build an IF Formula: Build an IF formula.