Lavamarine448
contestada

Sarah wants to separate the employee ID numbers from its middle letters. Help her use the MID function to set up
her formula
Employee ID numbers are in the format 123AB6789 and begin in cell A2
Select the cell where you want the information to be placed.
Type to begin the formula, and use the function
Within parentheses, add the argument
Press Enter to complete the formula
Intro
Done

Respuesta :

rebeccacouickp0tn8p

Answer:

1. =

2. MID

3. A2, 4, 2

Explanation:

Just took it on EDGE. :)

Below is an image with the formula.

The correct formula is :

  1. =
  2. MID
  3. A2,4,2

What is the mid formula?

The Excel MID function extracts a given number of characters from the middle of a supplied text string.

For example, =MID("apple",2,3) returns "ppl".

How do I substitute multiple conditions in Excel?

SUBSTITUTE(A2, "1", "2") - Substitutes all occurrences of "1" with "2". The SUBSTITUTE function in Excel is case-sensitive.

For example, the following formula replaces all instances of the uppercase "X" with "Y" in cell A2, but it won't replace any instances of the lowercase "x"

Learn more about Formula / Function here:

brainly.com/question/27927845

#SPJ2

Ver imagen Tutorconsortium323