Is it extracted from the left? Or start extracting from the right?
Or extract from the middle part of the array? Or do you want to start with a specific string?
You didn't specify the specific requirements.
Left function: Select from the left. For example, if you extract five characters from the left, you can use the formula =LEFT(A 1, 5).
Right function: extract from the right. For example, the formula =RIGHT(A 1, 5) can be used to extract 5 characters from the right.
Intermediate function: extract from the middle part. For example, starting from the fifth character and extracting 10 characters to the right, you can use the formula =MID(A 1 5, 10).
FIND function: from the searched string, extract 5 characters and use the formula =FIND ("string ",A 1, 5).