In Excel, looking for a way to pull the 10 characters after the first percentage…
- User
In Excel, looking for a way to pull the 10 characters after the first percentage character in a cell
Assistant
To pull 10 characters after the first
%character in a cell in Excel, you can use a formula combining several text functions:FIND,MID, and optionallyIFERROR.Assuming your text is in cell A1, here's the formula:
=MID(A1, FIND("%", A1) + 1, 10)Explanation:
FIND("%", A1)finds the position of the first%character.+ 1starts extracting after the%.MID(..., ..., 10)pulls the next 10 characters starting from that point.
Optional: Handle cases where
%isn't foundTo avoid a
#VALUE!error if%isn't present, wrap it inIFERROR:=IFERROR(MID(A1, FIND("%", A1) + 1, 10), "")This will return an empty string (
"") if no%is found.Let me know if you want to extract all characters after
%, not just 10.
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.