Find Replace Examples

Please purchase the course before starting the lesson.

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.

Back to: Intermediate Excel Course > Tools for text