After the Civil Rights Act of 1964 was passed, the Supreme Court upheld the law's application to the private sector, on the grounds that Congress has the power to regulate commerce between the States.espite its lack of influence during its time, the Civil Rights Act of 1964 had considerable impact on later civil rights legislation in the United States.
This cell must be different than the cell in which your target text appears. If you haven't already added your data to Excel, you'll need to do so first. 2. Type the MID formula into your selected cell. MID chops characters off of the beginning and end of your selected cell's text.
Green Triangle. The green triangle appears in the upper left hand corner of a cell when there is an error in a formula. Sometimes Excel will report an error when you use text in a box and the program believes it is part of a formula. When you click on the green triangle there will be a yellow box that looks like a road sign with an exclamation point in it. This button is the Trace Error option that will help you correct your formula.