How to Extract Numbers from Cells in Excel

Date:2022-12-20 Author:Sandra

In our previous tutorial, we learned how to extract numbers from text in Excel cells.

In our today’s sharing, we’ll keep learning something about this. That’s how to extract numbers from cells in Excel. We can do this in a very easy way. let’s check this out.

Looking at this screenshot, in these 18 cells, some are containing numbers, and others words.

How to Extract Numbers from Cells in Excel

How should we extract all the number cells? (Cells containing numbers)

Just copy and paste. Select the area of these 18 cells and press Ctrl and C keys together to copy them.

How to Extract Numbers from Cells in Excel

Then right-click on any blank cell.

How to Extract Numbers from Cells in Excel

Choose the Paste Special of the list.

How to Extract Numbers from Cells in Excel

Check the option Add and hit ok.

How to Extract Numbers from Cells in Excel

Now all the number cells are extracted here. Do you have any other way to handle this? Please feel free to leave a comment. See you next time~

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *