F5F Stay Refreshed Software General Software Excel and WPS - what is the MID function?

Excel and WPS - what is the MID function?

Excel and WPS - what is the MID function?

A
AFKCosmos
Member
Find
183
06-11-2023, 07:23 AM
#1
Hi Everyone,
I'm trying to extract a specific middle section from a particular cell, but I'm uncertain about using the MID function correctly. The goal is to get text that includes 6 alphanumeric characters (12G3WR) from each cell, while ensuring each cell has a different length. I've attempted using MID with FIND and MID with SEARCH, but the results aren't what I expected. Could anyone provide the relevant formulas and explanations?
Reply
Reply
A
AFKCosmos
06-11-2023, 07:23 AM #1

Hi Everyone,
I'm trying to extract a specific middle section from a particular cell, but I'm uncertain about using the MID function correctly. The goal is to get text that includes 6 alphanumeric characters (12G3WR) from each cell, while ensuring each cell has a different length. I've attempted using MID with FIND and MID with SEARCH, but the results aren't what I expected. Could anyone provide the relevant formulas and explanations?

Reply
Reply
R
RoxWolf11
Junior Member
Find
5
06-15-2023, 06:02 PM
#2
When dealing with strings of varying lengths, you'll need to identify a shared element in each string and use that as the basis. In the examples provided, the target string consistently follows the 3rd "_". The coding task remains unchanged.
Reply
Reply
R
RoxWolf11
06-15-2023, 06:02 PM #2

When dealing with strings of varying lengths, you'll need to identify a shared element in each string and use that as the basis. In the examples provided, the target string consistently follows the 3rd "_". The coding task remains unchanged.

Reply
Reply