Excel for Data Analysis and Visualization

Find Replace Examples

You don’t have access to this lesson

Please purchase this course, or sign in if you’re already enrolled, to access the course content.

Find Replace Ex 1

We need to determine which orders are not yet picked by subtracting the Pick Qty from the Order Qty. There seems to be a problem with some of the numbers that need to be sorted out with a tool. It seems that there are comma’s where there should be full stops.

Find Replace Ex 2

What are the totals of these 2 columns?

Create a sum in cell C100 and D100 (yellow cells)

If it won’t work, figure out how to change the cells to be numbers!

To see the full course contents click here.

0 of 141 lessons complete (0%)
0
    0
    Your Cart
    Your cart is emptyReturn to Shop