Question

If there are three bits of useful data in here: "02-West-2635" What functions would you use to extract and separate them?

Option 1: MID, LEFT, RIGHT
Option 2: SUM, AVERAGE, COUNT
Option 3: IF, AND, OR
Option 4: HLOOKUP, VLOOKUP, INDEX

Answer 1

To extract and separate the three bits of useful data from the given string "02-West-2635", you can use the functions MID, LEFT, and RIGHT.

Step-by-step explanation:

To extract and separate the three bits of useful data from the given string "02-West-2635", you can use the functions MID, LEFT, and RIGHT. Here's how:

1. MID: Use the MID function to extract a specified number of characters from the middle of the string. For example, to extract "West", you can use MID("02-West-2635", 4, 4).
2. LEFT: Use the LEFT function to extract a specified number of characters from the left side of the string. For example, to extract "02", you can use LEFT("02-West-2635", 2).
3. RIGHT: Use the RIGHT function to extract a specified number of characters from the right side of the string. For example, to extract "2635", you can use RIGHT("02-West-2635", 4).